Hi Iniyan,
Will you be able to provide the query that you use, as well as the error
message that you received?
Regards,
Edwin
On Mon, 12 Aug 2019 at 01:57, Iniyan wrote:
> Hi,
>
> I was trying to do join between 2 collections. For that I have followed the
> tutorial how to create colocating co
Hi,
I was trying to do join between 2 collections. For that I have followed the
tutorial how to create colocating collection .
Created one collection with one shard and 2 replication factors.
Created another collection and added the query parameter
withCollection = first collection name.
Seems
ilto:erickerick...@gmail.com]
> Sent: Monday, July 29, 2019 3:19 PM
> To: solr-user@lucene.apache.org
> Subject: Re: Solr join query
>
> Vadim:
>
> Are you using streaming or the special “cross collection” join that requires
> colocated collection?
>
> > On Jul
t's working pretty well
>
> --
> Vadim
>
>> -Original Message-
>> From: Rajdeep Sahoo [mailto:rajdeepsahoo2...@gmail.com]
>> Sent: Monday, July 22, 2019 9:19 PM
>> To: solr-user@lucene.apache.org
>> Subject: Solr join query
>>
>> Can we join two solr collection based on multivalued field.
>
e.apache.org
> Subject: Solr join query
>
> Can we join two solr collection based on multivalued field.
Can we join two solr collection based on multivalued field.
They are logically different that is why kept in different collections.
Collection1: The purpose is to do Global Text Search for all objects through
multiple document types
Collection3: The purpose is to have search for some other type of objects
whose documents are in Millions and takes GBs size.
Put them in one collection
> Am 14.06.2019 um 07:17 schrieb Paresh :
>
> I am actually able to make this work by doing multiple JOINs -
> 1. Do query on Collection1
> 2. JOIN with Collection3 (document type1 field)
> 3. JOIN with Collection3 (document type2 field)
> 4. Do not fetch any data exce
I am actually able to make this work by doing multiple JOINs -
1. Do query on Collection1
2. JOIN with Collection3 (document type1 field)
3. JOIN with Collection3 (document type2 field)
4. Do not fetch any data except faceting information
But the other problem is, it is very slow.
Are there any o
Hi Erick,
I am able to achieve querying on Collection3 with INNER JOIN between two
document types and JOIN across collection1 using below mechanism. I am also
getting facetting information from collection3 along with data.
http://localhost:8983/solr/collection3/tcfts?wt=json&indent=on&start=0&row
Hi Erick,
I am able to achieve querying on Collection3 with INNER JOIN between two
document types and JOIN across collection1 using below mechanism. I am also
getting facetting information from collection3 along with data.
http://localhost:8983/solr/collection3/tcfts?wt=json&indent=on&start=0&row
How are you trying to do this? Streaming Expressions? ParallelSQL? What _Solr_
constructs are you planning on using?
Best,
Erick
> On Jun 12, 2019, at 7:33 AM, Paresh wrote:
>
> Hi,
>
> I have two collections both having different schema.
> Collection1: ID, Field1, Field2
> Collection3: ID, O
Hi,
I have two collections both having different schema.
Collection1: ID, Field1, Field2
Collection3: ID, Oc1, OC2, col3_Field1
ID1, col3_Oc1
I want to do following JOINs
(-)Query on Collection1
(-)Field2:value2
(-)JOIN across collection3 Field1 = collection3.col3_Field1
I have two cores and each core has a common field to join the query. I am
able to write Solr query for this.
Each core has a date field in the Solr.Second part of my query is to apply a
date condition on Solr cores by giving OR condition on each core's date
field.
Below is the SQL query that I am
it might make sense to test on the recent versions of Solr.
On Sun, Apr 8, 2018 at 8:21 PM, manuj singh wrote:
> Hi all,
> I am trying to debug a problem which i am facing and need some help.
>
> I have a solr query which does join on 2 different cores. so lets say my
> first core has following
Hi all,
I am trying to debug a problem which i am facing and need some help.
I have a solr query which does join on 2 different cores. so lets say my
first core has following 3 docs
{ "id":"1", "m_id":"lebron", "some_info":"29" }
{ "id":"2", "m_id":"Wade", "matches_win":"29" }
{ "id":"3", "m_id
Hello.
There is no way to make it work fast. It executes expensive join operation
for all docs/terms and then post filters with resulting docset.
On Mon, Feb 5, 2018 at 9:53 AM, Aashish Agarwal wrote:
> Hi
>
> I am using join query that joins 2 cores to get result. Since, number of
> docs in bot
Hi
I am using join query that joins 2 cores to get result. Since, number of
docs in both the cores are too high so I want to use post filter with join
query. But that is not working by providing cost=100.
Is it implemented for join filter query? I use solr 4.6.0
Thanks,
Aashish
Hello,
I'm wondering what performance improvements occurred in Solr JOIN from
4.10.0 to 7.x. I noticed that the performance is quicker, but from looking
at the code in JoinQParserPlugin it isn't much change.
I saw that in Solr 5.x passing score=none would invoke Lucene's join
a
> I am reading similar issues and it says "initial join implementation is
O(nterms)".. What does this mean?
It enumerates all par_id terms every time. As an alternative for some of
field types you can add {!join ... score=none ...}.. to trigger Lucene's
join algorithm with O(fromDocs) ie if subord
First of all, Solr is a _search_ engine, it wasn't built to be an
RDBMS. Whenever I see this question (paraphrasing) "I've indexed my
tables and want to use Solr just like a DB" I cringe.
The join performance goes up with the number of unique values for the
join field. High-cardinality fields are
I am facing a performance problem and could narrow it down to a join query
that we are using. The join is on a unique field.
We have a person profile stored in RDB in a relational way. Like person
name table , address table etc. SOLR indexes are build using this RDB
data,Each children is stored as
You may want to look at fetch function of Streaming expressions
http://lucene.apache.org/solr/guide/6_6/stream-decorators.html
Thanks,
Susheel
On Tue, Sep 12, 2017 at 11:11 AM, Brian Yee wrote:
> I have one solr collection used for auto-suggestions. If I submit a query
> with q="coffe", I will
I have one solr collection used for auto-suggestions. If I submit a query with
q="coffe", I will get a responses back with documents that have a field
suggestion="coffee", "coffee table", "coffee maker", etc. I want to know if
those suggestions would have results if I used them to query a second
I am using following one:
http://lucene.apache.org/solr/5_4_1/solr-core/org/apache/solr/search/join/ScoreJoinQParserPlugin.html
q={!join from=id to=id fromIndex=B}id:*
2017-06-12 20:05 GMT-07:00 Zheng Lin Edwin Yeo :
> What is the query that you used to do the Join?
>
> There is the Streaming exp
What is the query that you used to do the Join?
There is the Streaming expression which has the various Join function, but
it requires Solr version 6 onward.
https://cwiki.apache.org/confluence/display/solr/Streaming+Expressions
Regards,
Edwin
On 13 June 2017 at 05:25, Ray Niu wrote:
> Hi:
>
Hi:
We encounter an issue when using join query in Solr Cloud, our version
is 5.5.2. We will query collection A and join with Collection B in the
runtime, collection A and B always co-exist in the same node.
Sometimes we found collection B was down for some reason, while
collection A was stil
nd complex as you use Joins ( Ref
> <http://lucene.472066.n3.nabble.com/Solr-6-Use-facet-
> with-Streaming-Expressions-LeftOuterJoin-td4290526.html>
> ).
>
>
>
> --
> View this message in context: http://lucene.472066.n3.
> nabble.com/SOLR-JOIN-tp4322744p4322781.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
ly use features like facet. Facets get
difficult and complex as you use Joins ( Ref
<http://lucene.472066.n3.nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin-td4290526.html>
).
--
View this message in context:
http://lucene.472066.n3.nabble.com/SOLR-JOIN-tp4322744p
That seems difficult if not impossible. The joins are just complex queries,
with the same data set.
> On Feb 28, 2017, at 11:37 PM, Nitin Kumar wrote:
>
> Hi,
>
> Can we use join query for more than 2 cores in solr. If yes, please provide
> reference or example.
>
> Thanks,
> Nitin
Hi,
Can we use join query for more than 2 cores in solr. If yes, please provide
reference or example.
Thanks,
Nitin
t=true
But When I query like this why its showing all records(100), I know I am in
the same core but why its behaving strange?:
http://localhost:7161/solr/Book/select?q=%3A&fq=%7B!join+fromIndex%3DBook+from%3DGroupID+to%3DGroupID%7D%2BIsPrimary%3A1&rows=10&wt=xml&indent=true
If
Ok, thanks for your answer! That's what I thought but just wanted to be
sure.
Best regards,
Elisabeth
2016-05-21 2:02 GMT+02:00 Erick Erickson :
> Gosh, I'm not even sure how to start to form such a query.
>
> Let's see, you have StreetB in some city identified by postal code P.
>
> Is what you'
Gosh, I'm not even sure how to start to form such a query.
Let's see, you have StreetB in some city identified by postal code P.
Is what you're wanting "return me all pairs of documents within that
postal code that have all the terms matching and the polygons enclosing
those streets plus some dis
Hello all,
I was wondering if there was a solr solution for a problem I have (and I'm
not the only one I guess)
We use solr as a search engine for addresses. We sometimes have requests
with let's say for instance
street A close to street B City postcode
I was wondering if some kind of join betw
ubject: Re: Solr Join between two indexes taking too long.
Russ,
Do you mean you accelerate only sidecase with small cardinality, or your
problem is resolved in general and 2.3 sec is fine for you?
Regarding longValues. Is it multivalued? It might work if {!join} parser pass
multipleValuesPerDocu
>
> Thanks for your help Mikhail and Upayavira now I just need to get the firm
> to move to 5.3 ☺
>
> Russ.
>
>
> -Original Message-
> From: Mikhail Khludnev [mailto:mkhlud...@griddynamics.com]
> Sent: 14 September 2015 15:54
> To: solr-user
> Subject: Re: Solr
--
From: Mikhail Khludnev [mailto:mkhlud...@griddynamics.com]
Sent: 14 September 2015 15:54
To: solr-user
Subject: Re: Solr Join between two indexes taking too long.
Why? It's enough to just open index by Solr 5.3 instance. No need to reindex.
On Mon, Sep 14, 2015 at 4:57 PM, Russell
Russ.
>
> -Original Message-
> From: Russell Taylor
> Sent: 11 September 2015 14:00
> To: solr-user@lucene.apache.org
> Subject: RE: Solr Join between two indexes taking too long.
>
> It will take a little while to set-up a 5.3 vers
Looks like I won't be able to test this out on 5.3.
Thanks for all your help.
Russ.
-Original Message-
From: Russell Taylor
Sent: 11 September 2015 14:00
To: solr-user@lucene.apache.org
Subject: RE: Solr Join between two indexes taking too long.
It will take a little while to set
It will take a little while to set-up a 5.3 version, hopefully I'll have some
results later next week.
From: Mikhail Khludnev [mkhlud...@griddynamics.com]
Sent: 11 September 2015 12:59
To: Russell Taylor
Subject: Re: Solr Join between two indexes taking too
I'll try that Thanks Upayavira.
From: Upayavira [u...@odoko.co.uk]
Sent: 09 September 2015 19:30
To: solr-user@lucene.apache.org
Subject: Re: Solr Join between two indexes taking too long.
I've never reviewed that join query debug info - very i
from=longValue to=longValue
> > fromIndex=indexB}universe:LARGE",
> > "parsedquery": "JoinQuery({!join from=longValue to=longValue
> > fromIndex=indexB}universe:LARGE)",
> > "parsedquery_toString": "{!join from=longValue to=longValue
> > fromIndex=indexB}universe:LAR
;200076769985": "\n1.0 = (MATCH)
> org.apache.solr.search.JoinQuery$JoinQueryWeight@7a5d18ac , product
> of:\n 1.0 = boost\n 1.0 = queryNorm\n",
> "200076769986": "\n1.0 = (MATCH)
> org.apache.solr.search.JoinQuery$JoinQueryWeight@6d601adc , pr
che.solr.search.JoinQuery$JoinQueryWeight@118f9aef , product
> of:\n 1.0 = boost\n 1.0 = queryNorm\n",
> "200076769985": "\n1.0 = (MATCH)
> org.apache.solr.search.JoinQuery$JoinQueryWeight@7a5d18ac , product
> of:\n 1.0 = boost\n 1.0
rg.apache.solr.search.JoinQuery$JoinQueryWeight@6d601adc , product of:\n 1.0
= boost\n 1.0 = queryNorm\n",
"200076769987": "\n1.0 = (MATCH)
org.apache.solr.search.JoinQuery$JoinQueryWeight@2e262f31 , product of:\n 1.0
= boost\n 1.0 = queryNorm\n",
"2
To explain what a join does:
It goes over to the joined index, and executes a query. This results in
a list of "ids" that will be used to do a search on the main index. The
more of these ids there are, the worse performance will be. Thus, if you
have 100k documents that match in the join core, you
o the following query expressed, for convenience,
in sql:
select * from 'security information' where portfolio id = 'X'.
Of course, this is a simple idea in sql, one simply joins the two indexes on
security id. However, when we perform a solr join our response time is
app
Hello Russ,
It's an interesting case! Can you get a brief context?
- is it possible to keep both type of data at the same core? Why not?
- can you manually shard both indices by those longValues?
- It seems like you query a plenty of data, don't you have another
query/filter to intersect that join
Hi,
I hope somebody can help.
We have two indexes, one which holds the descriptive data and the other one
which holds lists of docs which are
of a certain type (called universes in our world). They need to be joined
together to show a list of data from indexA
where a filtered indexB (by univers
Wed, Sep 2, 2015 at 9:05 AM, Maulin Rathod wrote:
> As per this link (http://wiki.apache.org/solr/Join) Solr Join is supported
> only for cores in single shard. Is there any plan to support Join Across
> cores in Multiple Shard?
As per this link (http://wiki.apache.org/solr/Join) Solr Join is supported
only for cores in single shard. Is there any plan to support Join Across
cores in Multiple Shard?
I was to comment the very same solution!
I think this will satisfy the user requirement.
Thanks Antonio!
Cheers
2015-07-13 12:22 GMT+01:00 Antonio David Pérez Morales <
adperezmora...@gmail.com>:
> Hi again Yusnel
>
> Just to confirm, I have tested your use case and the query which returns
> wha
Hi again Yusnel
Just to confirm, I have tested your use case and the query which returns
what you need is this one:
http://localhost:8983/solr/category/select?q={!join from=categoryId
fromIndex=product to=id}*:*&wt=json&indent=true&fq=name:clothes&hl=false
Please, check and let us know if it wor
Hi Yusnel
I think the query is invalid. It should be "q=clothes&fq={!join
from=type_id to=id fromIndex=products}" or "q=*:*&fq={!join from=type_id
to=id fromIndex=products}clothes" as long as you are using an edismax
parser or df param for default field, where "clothes" query is matched to.
Regar
I have 2 indexes
products {
id,
name,
type_id
..
}
and
categories {
id,
name
..
}
and I want to get all categories that match a name and have products in it.
my best guess would be:
http://localhost:8983/solr/categories/select?q=clothes&fl=*,score&fq={!join
from=type_id to=
s would work too..
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Solr-join-Boost-in-single-query-tp4190825p4190911.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
--
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics
<http://www.griddynamics.com>
Yes Mikhail. Similar to the one you mentioned. The only difference is that,
in my case a uinon between two cores would work too..
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-join-Boost-in-single-query-tp4190825p4190911.html
Sent from the Solr - User mailing list
ither of the
> cores? Is that possible with Solr?
>
> Raavi
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Solr-join-Boost-in-single-query-tp4190825.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
--
Sinc
Eric,
I am trying to boost the fields that match both the cores to the top of the
list. Or atleast get a union of the two cores.
Thanks,
Raavi
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-join-Boost-in-single-query-tp4190825p4190861.html
Sent from the Solr
Or do you think there is a way to do a union between the two cores?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-join-Boost-in-single-query-tp4190825p4190860.html
Sent from the Solr - User mailing list archive at Nabble.com.
trying to solve is?
Best,
Erick
On Tue, Mar 3, 2015 at 7:52 PM, sraav wrote:
> David,
> Thank you for the reply.
>
> How about boosting on the records that match the both the cores or may be
> boosting on join may be? Is there a way we can do that?
>
> Raav
>
>
>
> -
David,
Thank you for the reply.
How about boosting on the records that match the both the cores or may be
boosting on join may be? Is there a way we can do that?
Raav
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-join-Boost-in-single-query-tp4190825p4190852.html
p://lucene.472066.n3.nabble.com/Solr-join-Boost-in-single-query-tp4190825p4190849.html
Sent from the Solr - User mailing list archive at Nabble.com.
David,
Is it possible to write a query to join two cores and either bring back data
from the two cores or to boost on the data coming back from either of the
cores? Is that possible with Solr?
Raavi
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-join-Boost-in
shard which gave data for the join query {!join from=id
> to=uid fromIndex=A}type:xxx
>
> meaning if the document is found in shard 2 for collection A, the query is
> only searching the data in shard 2 even for collection B also.
>
>
>
> --
> View this message in context:
Hi,
It's just FYI,
Join query is (currently) not supported at distributed environment. It
would be same at SolrCloud mode (I have not tried.)
Please see "Limitations" notation this page, if you have not.
https://wiki.apache.org/solr/Join
Thanks,
Tomoko
2014-12-16 9:04 GMT+09:00
data for the join query {!join from=id
to=uid fromIndex=A}type:xxx
meaning if the document is found in shard 2 for collection A, the query is
only searching the data in shard 2 even for collection B also.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-join-not-working-
I have the following scenario:
Collection A has:
Collection B has:
http://localhost:8983/solr/B/select?wt=json&indent=true&q=*:*&fq={!join
from=id to=uid fromIndex=A}type:xxx
Any help?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-join-not
We simply index parent and child documents with the same field value,
and group on that, querying both parent and child documents. If you
boost the parent it will show up as the first result in the group. Then
you get all related documents together. in the same group.
-Mike
On 12/02/2014 02:
Hi,
Thanks for the response, I have considered grouping often, but grouping does
not return the parent document, just the group id. I would still have to add
something to take the group id’s and get the parent documents.
Thanks
Darin
> On Dec 2, 2014, at 2:11 PM, Michael Sokolov
> wrote:
>
Have you considered using grouping? If I understand your requirements,
I think it does what you want.
https://cwiki.apache.org/confluence/display/solr/Result+Grouping
On 12/02/2014 12:59 PM, Darin Amos wrote:
Thanks!
I will take a look at this. I do have an additional question, since after a
Thanks!
I will take a look at this. I do have an additional question, since after a
bunch of digging I believe I am going to run into another dead end.
I want to execute the join (or rollup) query, but I want the facets to
represent the facets of all the child documents, not the resulting produ
Hello,
AFAIK {!join} doesn't supply any meaningful scores.
I can suggest https://issues.apache.org/jira/browse/SOLR-6234
On Tue, Dec 2, 2014 at 4:35 AM, Darin Amos wrote:
> Hello,
>
> I had sent an email a few days ago talking about implementing a custom
> rollup query component. I have changed
Hello,
I had sent an email a few days ago talking about implementing a custom rollup
query component. I have changed directions a little bit because I have learned
about the JoinQuery.
I have an index that contains a combination of parent and child documents. The
parent child relationship is a
't have to keep the
>>>> security information in each of my primary Solr documents.
>>>>
>>>> I just posted the gist at
>>>> https://gist.github.com/pdurbin/4d27fea7b431ef3bf4f9 as an example of
>>>> my working Sol
ocuments.
>>>
>>> I just posted the gist at
>>> https://gist.github.com/pdurbin/4d27fea7b431ef3bf4f9 as an example of
>>> my working Solr JOIN based on data in `before.json` . Permissions per
>>> user are embedded in the primary documents lik
filter-solution-for-Solr-tp4126992p4126994.html
>>
>> I'm trying to tweak this pattern so that I don't have to keep the
>> security information in each of my primary Solr documents.
>>
>> I just posted the gist at
>> https://gist.github.com/pdurbin/4d27fea7
weak this pattern so that I don't have to keep the
> security information in each of my primary Solr documents.
>
> I just posted the gist at
> https://gist.github.com/pdurbin/4d27fea7b431ef3bf4f9 as an example of
> my working Solr JOIN based on data in `before.json` . Permission
each of my primary Solr documents.
I just posted the gist at
https://gist.github.com/pdurbin/4d27fea7b431ef3bf4f9 as an example of
my working Solr JOIN based on data in `before.json` . Permissions per
user are embedded in the primary documents like this:
{
"id": "data
Hello everyone :)
I have an index for groupId and one for product. For an input search
keyword, I only want to boost the result if the keyword appears in both
groupId and product indices.
I was able to get Solr join with fq to work with the following syntax:
example: q=searchTerm&fq={!join
Thank you for the clarification.
We really need scoring with solr joins, but as you can see I'm not a
specialist in solr development.
We would like to hire somebody with more experience to write a qparser
plugin for scoring in joins and donate the source code to the community.
Any suggestion
Right,
The examples posted before had a trick (both weren't pure join queries
thats why the results had score).
Having a pure join query (q={!join from=id to=id}printer) gives all the
scores as 1 as Moritz said).
Regards.
On Wed, Apr 9, 2014 at 3:13 PM, Mikhail Khludnev wrote:
> On Wed
On Wed, Apr 9, 2014 at 1:33 PM, wrote:
> Hello Mikhail,
>
> thx for the clarification. I'm a little bit confused by the answer of
> Alvaro, but my own tests didn't result in a proper score, so I think you're
> right and it's still not implemented.
>
> What do you mean with the "impedance between
Hello Mikhail,
thx for the clarification. I'm a little bit confused by the answer of
Alvaro, but my own tests didn't result in a proper score, so I think
you're right and it's still not implemented.
What do you mean with the "impedance between Lucene and Solr"?
Why isn't the possibility of
On Thu, Apr 3, 2014 at 1:42 PM, wrote:
> Hello,
>
> referencing to this issue:
> https://issues.apache.org/jira/browse/SOLR-4307
>
> Is it still not possible with the solr query time join to use scoring?
>
It's not implemented still.
https://github.com/apache/lucene-solr/blob/trunk/solr/core/src/
Hi,
The defect you are referencing is closed with a resolution of *Invalid*, so
it seems the scoring is working fine with the join. I've made the next two
tests on my own data and seems it is working:
*TestA*
- fl=id,score
- q=notebook
- fq={!join from=product_list to=id fromIndex=prod
Hello,
referencing to this issue:
https://issues.apache.org/jira/browse/SOLR-4307
Is it still not possible with the solr query time join to use scoring?
Do I still have to write my own plugin or is there a plugin somewhere
I could use?
I never wrote a plugin for solr before, so I would prefe
lize the data if possible.
Best,
Erick
On Sun, Jan 12, 2014 at 9:55 PM, solr2020 wrote:
> Hi All,
>
> Can anyone please explain how solr join query works in solr4.2.
> we have 2 different documents.Both are in the same index.
>
> document1 contains the columns:
>
> docdate
anyone please explain how solr join query works in solr4.2.
we have 2 different documents.Both are in the same index.
document1 contains the columns:
docdate: 01-12-2012
previousmonthdate :01-11-2012
price:15
and some more fields.
document2 contains:
docdate :01-11-2012
previousmonthdate :01-10
Hi All,
Can anyone please explain how solr join query works in solr4.2.
we have 2 different documents.Both are in the same index.
document1 contains the columns:
docdate: 01-12-2012
previousmonthdate :01-11-2012
price:15
and some more fields.
document2 contains:
docdate :01-11-2012
Hi guys,
I was studying in deep the join feature, and I noticed that in Solr , the
join query parser is not working in scoring.
If you add the parameter "scoreMode" it is completely ignored...
Checking the source code it's possible to see that the join query is built
as follow :
public class Join
Solr User Group,
I would like to return a hierarchical data relationship when somebody
queries for a parent doc in solr. This sort of relationship doesn't currently
exist in our core as the use-case has been to search for a specific document
only. However, here's kind of an example
Generally, you need to flatten and denormalize your data before you place it
in Solr. But, Solr does have a limited join capability that does handle some
cases reasonably well:
http://wiki.apache.org/solr/Join
For example...
"This Solr request...
/solr/collection1/select ? fl=xxx,yy
from doc
where field2 = 'B' and field1 not in (select field1 from doc where
field2 = 'A')
The join operator is the equivalent of the SQL in operator.
Can we use the solr join or another function to implements our needs?
Thanks
each entity or single one for all
--
View this message in context:
http://lucene.472066.n3.nabble.com/3-Way-Solr-Join-tp3815979p3990515.html
Sent from the Solr - User mailing list archive at Nabble.com.
i already have multvalued relatedVideoId field which i m trying to join with
id
--
View this message in context:
http://lucene.472066.n3.nabble.com/solr-join-tp3881832p3882034.html
Sent from the Solr - User mailing list archive at Nabble.com.
Apr 3, 2012, at 10:56 AM, abhayd wrote:
> hi
> I am trying to use solr join in following way
> q={!join+from=relatedVideoId+to=id}id:1234
>
> This works fine but anyway for me to get the original document id:1234 along
> with relatedVideoId's if exists?
>
>
> --
&g
hi
I am trying to use solr join in following way
q={!join+from=relatedVideoId+to=id}id:1234
This works fine but anyway for me to get the original document id:1234 along
with relatedVideoId's if exists?
--
View this message in context:
http://lucene.472066.n3.nabble.com/solr
I know it goes against the grain here for a DB
person, but... denormalize. Really. Solr does
many things well, but whenever you start
trying to make it do database-like stuff you need
to back up and re-think things.
Simplest thing: Try indexing one record
for each customer/purchase/complaint
t
1 - 100 of 126 matches
Mail list logo
