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
