Hi Dennis/Joel,
Thank you for your help to date - I must say this user group is very
responsive :-)
Cheers
Akiel
From: Dennis Gove
To: solr-user@lucene.apache.org
Date: 05/01/2016 13:22
Subject:Re: Solr 6 Distributed Join
Akiel,
https://issues.apache.org/jira/browse
e, for the above query, I am joining the id field on the e1 field,
> so the id field needs to be in the fl and sort property of the left-hand
> stream, and e1 needs to be in the fl and sort property in the right-hand
> stream foe the join to work.
>
> Cheers
>
> Akiel
>
>
property of the left-hand
stream, and e1 needs to be in the fl and sort property in the right-hand
stream foe the join to work.
Cheers
Akiel
From: Joel Bernstein
To: solr-user@lucene.apache.org
Date: 24/12/2015 15:51
Subject:Re: Solr 6 Distributed Join
I haven't ha
any joins were covered in
> your tests? If yes, can you make any suggestions for what I could be doing
> wrong?
>
> Cheers
>
> Akiel
>
>
>
> From: Joel Bernstein
> To: solr-user@lucene.apache.org
> Date: 22/12/2015 13:03
> Subject:Re: Solr 6 Di
:{"docs":[
> {"e1":"1","id":"3"},
> {"EOF":true,"RESPONSE_TIME":58}]}}
>
> Deleting the document with id 3, and rerunning the query (see above)
> returned
>
> {"result-set":{"docs":[
> {"
quot;:[
> {"e1":"1","id":"3"},
> {"EOF":true,"RESPONSE_TIME":58}]}}
>
> Deleting the document with id 3, and rerunning the query (see above)
> returned
>
> {"result-set":{"docs":[
> {"e1":"
quot;,"id":"3"},
{"EOF":true,"RESPONSE_TIME":58}]}}
Deleting the document with id 3, and rerunning the query (see above)
returned
{"result-set":{"docs":[
{"e1":"1","id":"4"},
{"EOF":true
Thank you for the help.
I am working through what I want to do with the join - will let you know
if I hit any issues.
From: Joel Bernstein
To: solr-user@lucene.apache.org
Date: 17/12/2015 15:40
Subject:Re: Solr 6 Distributed Join
One thing to note about the hashJoin is
ld in the join - adding
>>> the e1 field to the fl parameter of the second search function gave the
>>> result I expected:
>>>
>>>
>>> http://localhost:8983/solr/gettingstarted/stream?stream=innerJoin(search(gettingstarted
>>>
>>> , fl="
q=text:John, sort="id
>> asc",zkHost="localhost:9983",qt="/export"), search(gettingstarted,
>> fl="id,e1", q=text:Friends, sort="id
>> asc",zkHost="localhost:9983",qt="/export"), on="id=e1")
>>
>&
l="id,e1", q=text:Friends, sort="id
> asc",zkHost="localhost:9983",qt="/export"), on="id=e1")
>
> I am still interested in whether we can specify a join, using an arbitrary
> number of searches.
>
> Cheers
>
> Akiel
>
ot;), on="id=e1")
I am still interested in whether we can specify a join, using an arbitrary
number of searches.
Cheers
Akiel
From: Akiel Ahmed/UK/IBM@IBMGB
To: solr-user@lucene.apache.org
Date: 16/12/2015 17:05
Subject:Re: Solr 6 Distributed Join
Hi Dennis,
Tha
t;s2.id=s3.e2")
Sorry if the query does not make sense, but given the data above my
intention is to find a single result made up of 3 documents:
s1.id=1,s2.id=8,s3.id=25
Is that possible? If yes, will Solr 6 support an arbitrary number of
queries and associated joins?
Cheers
Akiel
F
Akiel,
Without seeing your full url I assume that you're missing the
stream=innerJoin(.) part of it. A full sample url would look like this
http://localhost:8983/solr/careers/stream?stream=innerJoin(search(careers,
fl="personId,companyId,title", q=companyId:*, sort="companyId
asc",zkHost="loca
14 matches
Mail list logo
