lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruno Mannina <bmann...@free.fr>
Subject Re: Newbie: Searching across 2 collections ?
Date Wed, 06 Jan 2016 22:56:17 GMT
Yeah ! it works with your method !

thanks a lot Esther !


Le 06/01/2016 19:15, Esther-Melaine Quansah a écrit :
> 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
>>
>


---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus
Avast.
http://www.avast.com


Mime
View raw message