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 <bmann...@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 <bmann...@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 <bmann...@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 <bmann...@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 >
