lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Esther-Melaine Quansah <esther.quan...@lucidworks.com>
Subject Re: Newbie: Searching across 2 collections ?
Date Wed, 06 Jan 2016 18:15:56 GMT
Ok, so join won’t work. Distributed search is your answer. This worked for me:

http://localhost:8983/solr/temp/select?shards=localhost:8983/solr/job,localhost:8983/solr/temp&q=*:*
<http://localhost:8983/solr/temp/select?shards=localhost:8983/solr/job,localhost:8983/solr/temp&q=*:*>

so for you it’d look something like 

http://localhost:8983/solr/c1/select?shards=localhost:8983/solr/c1,localhost:8983/solr/c2&q=fid:34520196
<http://localhost:8983/solr/c1/select?shards=localhost:8983/solr/c1,localhost:8983/solr/c2&q=fid:34520196>
and obviously, you’ll just choose the ports that correspond to your configuration.

Esther 
> On Jan 6, 2016, at 9:36 AM, Bruno Mannina <bmannina@free.fr> wrote:
> 
> :( not work for me
> 
> http://my_adress:my_port/solr/c1/select?q={!join from=fid to=fid fromIndex=c2}fid:34520196&wt=json
> 
> the result is always the same, it answer only for c1
> 34520196 has result in both collections
> 
> 
> 
> Le 06/01/2016 18:16, Binoy Dalal a écrit :
>> Bruno,
>> Use join like so:
>> {!join from=f1 to=f2 fromIndex=c2}
>> On c1
>> 
>> On Wed, 6 Jan 2016, 22:30 Bruno Mannina <bmannina@free.fr> wrote:
>> 
>>> Hi Ester,
>>> 
>>> yes, i saw it, but if I use:
>>> 
>>> q={!join from=fid to=fid}fid:34520196 (with or not &collection=c1,c2)
>>> 
>>> I have only the result from the collection used in the select/c1
>>> 
>>> Le 06/01/2016 17:52, esther.quansah@lucidworks.com a écrit :
>>>> Hi Bruno,
>>>> 
>>>> You might consider using the JoinQueryParser. Details here :
>>> https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-JoinQueryParser
>>>> Best,
>>>> Esther
>>>> 
>>>>> Le 6 janv. 2016 à 08:48, Bruno Mannina <bmannina@free.fr> a écrit
:
>>>>> 
>>>>> Same result on my dev' server, it seems that collection param haven't
>>> effect on the query...
>>>>> Q: I don't see on the solr 5.4 doc, the "collection" param for select
>>> handler, is it always present in 5.4 version ?
>>>>> Le 06/01/2016 17:38, Bruno Mannina a écrit :
>>>>>> I have a dev' server, I will do some test on it...
>>>>>> 
>>>>>> Le 06/01/2016 17:31, Susheel Kumar a écrit :
>>>>>>> I'll suggest if you can setup some some test data locally and
try this
>>>>>>> out.  This will confirm your understanding.
>>>>>>> 
>>>>>>> Thanks,
>>>>>>> Susheel
>>>>>>> 
>>>>>>>> On Wed, Jan 6, 2016 at 10:39 AM, Bruno Mannina <bmannina@free.fr>
>>> wrote:
>>>>>>>> Hi Susheel, Emir,
>>>>>>>> 
>>>>>>>> yes I check, and I have one result in c1 and in c2 with the
same
>>> query
>>>>>>>> fid:34520196
>>>>>>>> 
>>>>>>>> http://xxx.xxx.xxx.xxx:xxxx
>>>>>>>> 
>>> /solr/c1/select?q=fid:34520196&wt=json&indent=true&fl=id,fid,cc*,st&collection=c1,c2
>>>>>>>> { "responseHeader":{ "status":0, "QTime":1, "params":{
>>> "fl":"fid,cc*,st",
>>>>>>>> "indent":"true", "q":"fid:34520196", "collection":"c1,c2",
>>> "wt":"json"}},
>>>>>>>> "response":{"numFound":1,"start":0,"docs":[ {
>>>>>>>> 
>>>>>>>>          "id":"EP1680447",
>>>>>>>>          "st":"LAPSED",
>>>>>>>>          "fid":"34520196"}]
>>>>>>>>    }
>>>>>>>> }
>>>>>>>> 
>>>>>>>> 
>>>>>>>> http://xxx.xxx.xxx.xxx:xxxx
>>>>>>>> 
>>> /solr/c2/select?q=fid:34520196&wt=json&indent=true&fl=id,fid,cc*,st&collection=c1,c2
>>>>>>>> {
>>>>>>>>    "responseHeader":{
>>>>>>>>      "status":0,
>>>>>>>>      "QTime":0,
>>>>>>>>      "params":{
>>>>>>>>        "fl":"id,fid,cc*,st",
>>>>>>>>        "indent":"true",
>>>>>>>>        "q":"fid:34520196",
>>>>>>>>        "collection":"c1,c2",
>>>>>>>>        "wt":"json"}},
>>>>>>>>    "response":{"numFound":1,"start":0,"docs":[
>>>>>>>>        {
>>>>>>>>          "id":"WO2005040212",
>>>>>>>>          "st":"PENDING",
>>>>>>>>          "cc_CA":"LAPSED",
>>>>>>>>          "cc_EP":"LAPSED",
>>>>>>>>          "cc_JP":"PENDING",
>>>>>>>>          "cc_US":"LAPSED",
>>>>>>>>          "fid":"34520196"}]
>>>>>>>>    }}
>>>>>>>> 
>>>>>>>> 
>>>>>>>> I have the same xxx.xxx.xxx.xxx:xxxx (server:port).
>>>>>>>> unique key field C1, C2 : id
>>>>>>>> 
>>>>>>>> id data in C1 is different of id data in C2
>>>>>>>> 
>>>>>>>> Must I config/set something in solr ?
>>>>>>>> 
>>>>>>>> thanks,
>>>>>>>> Bruno
>>>>>>>> 
>>>>>>>> 
>>>>>>>> Le 06/01/2016 14:56, Emir Arnautovic a écrit :
>>>>>>>> 
>>>>>>>>> Hi Bruno,
>>>>>>>>> Can you check counts? Is it possible that first page
is only with
>>> results
>>>>>>>>> from collection that you sent request to so you assumed
it returns
>>> only
>>>>>>>>> results from single collection?
>>>>>>>>> 
>>>>>>>>> Thanks,
>>>>>>>>> Emir
>>>>>>>>> 
>>>>>>>>>> On 06.01.2016 14:33, Susheel Kumar wrote:
>>>>>>>>>> 
>>>>>>>>>> Hi Bruno,
>>>>>>>>>> 
>>>>>>>>>> I just tested this scenario in my local solr 5.3.1
and it returned
>>>>>>>>>> results
>>>>>>>>>> from two identical collections. I doubt if it is
broken in 5.4 just
>>>>>>>>>> double
>>>>>>>>>> check if you are not missing anything else.
>>>>>>>>>> 
>>>>>>>>>> Thanks,
>>>>>>>>>> Susheel
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> 
>>> http://localhost:8983/solr/c1/select?q=id_type%3Ahello&wt=json&indent=true&collection=c1,c2
>>>>>>>>>> responseHeader": {"status": 0,"QTime": 98,"params":
{"q":
>>>>>>>>>> "id_type:hello","
>>>>>>>>>> indent": "true","collection": "c1,c2","wt": "json"}},
>>>>>>>>>> response": {"numFound": 2,"start": 0,"maxScore":
1,"docs": [{"id":
>>> "1","
>>>>>>>>>> id_type": "hello","_version_": 1522623395043213300},{"id":
>>>>>>>>>> "3","id_type":"
>>>>>>>>>> hello","_version_": 1522623422397415400}]}
>>>>>>>>>> 
>>>>>>>>>> On Wed, Jan 6, 2016 at 6:13 AM, Bruno Mannina <bmannina@free.fr>
>>> wrote:
>>>>>>>>>> yes id value is unique in C1 and unique in C2.
>>>>>>>>>>> id in C1 is never present in C2
>>>>>>>>>>> id in C2 is never present in C1
>>>>>>>>>>> 
>>>>>>>>>>> 
>>>>>>>>>>> Le 06/01/2016 11:12, Binoy Dalal a écrit :
>>>>>>>>>>> 
>>>>>>>>>>> Are Id values for docs in both the collections
exactly same?
>>>>>>>>>>>> To get proper results, the ids should be
unique across both the
>>> cores.
>>>>>>>>>>>> On Wed, 6 Jan 2016, 15:11 Bruno Mannina <bmannina@free.fr>
>>> wrote:
>>>>>>>>>>>> Hi All,
>>>>>>>>>>>> 
>>>>>>>>>>>>> Solr 5.4, Ubuntu
>>>>>>>>>>>>> 
>>>>>>>>>>>>> I thought it was simple to request across
two collections with
>>> the
>>>>>>>>>>>>> same
>>>>>>>>>>>>> schema but not.
>>>>>>>>>>>>> I have one solr instance launch. 300
000 records in each
>>> collection.
>>>>>>>>>>>>> I try to use this request without having
both results:
>>>>>>>>>>>>> 
>>>>>>>>>>>>> http://my_adress:my_port
>>>>>>>>>>>>> /solr/C1/select?collection=C1,C2&q=fid:34520196&wt=json
>>>>>>>>>>>>> 
>>>>>>>>>>>>> this request returns only C1 results
and if I do:
>>>>>>>>>>>>> 
>>>>>>>>>>>>> http://my_adress:my_port
>>>>>>>>>>>>> /solr/C2/select?collection=C1,C2&q=fid:34520196&wt=json
>>>>>>>>>>>>> 
>>>>>>>>>>>>> it returns only C2 results.
>>>>>>>>>>>>> 
>>>>>>>>>>>>> I have 5 identical fields on both collection
>>>>>>>>>>>>> id, fid, st, cc, timestamp
>>>>>>>>>>>>> where id is the unique key field.
>>>>>>>>>>>>> 
>>>>>>>>>>>>> Can someone could explain me why it doesn't
work ?
>>>>>>>>>>>>> 
>>>>>>>>>>>>> Thanks a lot !
>>>>>>>>>>>>> Bruno
>>>>>>>>>>>>> 
>>>>>>>>>>>>> ---
>>>>>>>>>>>>> L'absence de virus dans ce courrier électronique
a été vérifiée
>>> par le
>>>>>>>>>>>>> logiciel antivirus Avast.
>>>>>>>>>>>>> http://www.avast.com
>>>>>>>>>>>>> 
>>>>>>>>>>>>> --
>>>>>>>>>>>>> 
>>>>>>>>>>>>> Regards,
>>>>>>>>>>>> Binoy Dalal
>>>>>>>>>>>> 
>>>>>>>>>>>> 
>>>>>>>>>>>> ---
>>>>>>>>>>> L'absence de virus dans ce courrier électronique
a été vérifiée
>>> par le
>>>>>>>>>>> logiciel antivirus Avast.
>>>>>>>>>>> http://www.avast.com
>>>>>>>> ---
>>>>>>>> L'absence de virus dans ce courrier électronique a été
vérifiée par
>>> le
>>>>>>>> logiciel antivirus Avast.
>>>>>>>> http://www.avast.com
>>>>>> ---
>>>>>> L'absence de virus dans ce courrier électronique a été vérifiée
par le
>>> logiciel antivirus Avast.
>>>>>> http://www.avast.com
>>>>> ---
>>>>> L'absence de virus dans ce courrier électronique a été vérifiée
par le
>>> logiciel antivirus Avast.
>>>>> http://www.avast.com
>>>>> 
>>> 
>>> ---
>>> L'absence de virus dans ce courrier électronique a été vérifiée par le
>>> logiciel antivirus Avast.
>>> http://www.avast.com
>>> 
>>> --
>> Regards,
>> Binoy Dalal
>> 
> 
> 
> ---
> L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
> http://www.avast.com
> 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message