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