Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Binoy Dalal 
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  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=fid:34520196=json
>
> this request returns only C1 results and if I do:
>
> http://my_adress:my_port
> /solr/C2/select?collection=C1,C2=fid:34520196=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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

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  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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Emir Arnautovic 

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=json=true=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  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  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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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




--
Monitoring * Alerting * Anomaly Detection * Centralized Log Management
Solr & Elasticsearch Support * http://sematext.com/

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Susheel Kumar 
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=json=true=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  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  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=fid:34520196=json
>>>
>>> this request returns only C1 results and if I do:
>>>
>>> http://my_adress:my_port
>>> /solr/C2/select?collection=C1,C2=fid:34520196=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
>
>

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

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:/solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:/solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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  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  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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Binoy Dalal 
Another diagnostic you can perform is to query for a doc you know is on the
other collection and see if it is returned. If it is then you might simply
not be seeing the results as emir says.

On Wed, 6 Jan 2016, 19:27 Emir Arnautovic 
wrote:

> 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=json=true=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  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  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=fid:34520196=json
> 
>  this request returns only C1 results and if I do:
> 
>  http://my_adress:my_port
>  /solr/C2/select?collection=C1,C2=fid:34520196=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
> >>
> >>
>
> --
> Monitoring * Alerting * Anomaly Detection * Centralized Log Management
> Solr & Elasticsearch Support * http://sematext.com/
>
> --
Regards,
Binoy Dalal

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Esther-Melaine Quansah 
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=*:*
 


so for you it’d look something like 

http://localhost:8983/solr/c1/select?shards=localhost:8983/solr/c1,localhost:8983/solr/c2=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  wrote:
> 
> :( not work for me
> 
> http://my_adress:my_port/solr/c1/select?q={!join from=fid to=fid 
> fromIndex=c2}fid:34520196=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  wrote:
>> 
>>> Hi Ester,
>>> 
>>> yes, i saw it, but if I use:
>>> 
>>> q={!join from=fid to=fid}fid:34520196 (with or not =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  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 
>>> 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:
 
>>> /solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
 
>>> /solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=c1,c2
>> responseHeader": {"status": 0,"QTime": 98,"params": {"q":

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Susheel Kumar 
Hi Bruno,  I just tested on 5.4 for your sake and it works fine.  You are
somewhere goofing up.  Please create a new simple schema different from
your use case with 2-3 fields with 2-3 documents and test this out
independently on your current problem.  That's what i can make suggestion
and did same to confirm this.

On Wed, Jan 6, 2016 at 11:48 AM, Bruno Mannina  wrote:

> 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  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:
 /solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
 /solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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 
>> 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  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=fid:34520196=json
>
> this request returns only C1 results and if I do:
>
> http://my_adress:my_port
> /solr/C2/select?collection=C1,C2=fid:34520196=json
>
> it returns only C2 results.
>
> I have 5 identical fields on both collection
> id, fid, st, cc, timestamp
>

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Shawn Heisey 
On 1/6/2016 2:41 AM, Bruno Mannina wrote:
> I try to use this request without having both results:
>
> http://my_adress:my_port/solr/C1/select?collection=C1,C2=fid:34520196=json
>
>
> this request returns only C1 results and if I do:
>
> http://my_adress:my_port/solr/C2/select?collection=C1,C2=fid:34520196=json
>
>
> it returns only C2 results.

Are you running in SolrCloud mode (with zookeeper)?  If you're not, then
the collection parameter doesn't do anything, and old-style distributed
search (with the shards parameter) will be your only option.

Thanks,
Shawn

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Susheel Kumar 
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  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:
> /solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
> /solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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  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  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=fid:34520196=json
>>
>> this request returns only C1 results and if I do:
>>
>> http://my_adress:my_port
>> /solr/C2/select?collection=C1,C2=fid:34520196=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
>
>

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread esther . quansah 
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  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  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:
 /solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
 /solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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  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  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=fid:34520196=json
> 
> this request returns only C1 results and if I do:
> 
> http://my_adress:my_port
> /solr/C2/select?collection=C1,C2=fid:34520196=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
>

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

Hi Ester,

yes, i saw it, but if I use:

q={!join from=fid to=fid}fid:34520196 (with or not =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  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  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:
/solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
/solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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  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  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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Binoy Dalal 
Bruno,
Use join like so:
{!join from=f1 to=f2 fromIndex=c2}
On c1

On Wed, 6 Jan 2016, 22:30 Bruno Mannina  wrote:

> Hi Ester,
>
> yes, i saw it, but if I use:
>
> q={!join from=fid to=fid}fid:34520196 (with or not =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  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 
> 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:
> >
> /solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
> >
> /solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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 
> 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 
> wrote:
> >
> > Hi All,
> >
> >> Solr 5.4, Ubuntu
> >>
> >> I thought it was simple to request across two collections with
> the
> >> same
> >> schema but not.
>

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

:( not work for me

http://my_adress:my_port/solr/c1/select?q={!join from=fid to=fid 
fromIndex=c2}fid:34520196=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  wrote:


Hi Ester,

yes, i saw it, but if I use:

q={!join from=fid to=fid}fid:34520196 (with or not =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  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 

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:


/solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:


/solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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 

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 

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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

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  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:
/solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
/solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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  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  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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 
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  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:
/solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
/solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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  
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  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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

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=*:*
 


so for you it’d look something like

http://localhost:8983/solr/c1/select?shards=localhost:8983/solr/c1,localhost:8983/solr/c2=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  wrote:

:( not work for me

http://my_adress:my_port/solr/c1/select?q={!join from=fid to=fid 
fromIndex=c2}fid:34520196=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  wrote:


Hi Ester,

yes, i saw it, but if I use:

q={!join from=fid to=fid}fid:34520196 (with or not =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  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 

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:


/solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:


/solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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 

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 

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.

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

Hi Shawn,

thanks for this info, I use solr alone on my own server.

Le 06/01/2016 20:13, Shawn Heisey a écrit :

On 1/6/2016 2:41 AM, Bruno Mannina wrote:

I try to use this request without having both results:

http://my_adress:my_port/solr/C1/select?collection=C1,C2=fid:34520196=json


this request returns only C1 results and if I do:

http://my_adress:my_port/solr/C2/select?collection=C1,C2=fid:34520196=json


it returns only C2 results.

Are you running in SolrCloud mode (with zookeeper)?  If you're not, then
the collection parameter doesn't do anything, and old-style distributed
search (with the shards parameter) will be your only option.

Thanks,
Shawn






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

Re: Newbie: Searching across 2 collections ?

2016-01-06 Thread Bruno Mannina 

Hi,

is it possible that was the problem wrote by Shawn and you have 
SolrCloud mode (with zookeeper) ?


The solution gives by Esther works fine so it's ok for me :)

**

Are you running in SolrCloud mode (with zookeeper)?  If you're not, then
the collection parameter doesn't do anything, and old-style distributed
search (with the shards parameter) will be your only option.

Thanks,
Shawn

***

Le 06/01/2016 19:17, Susheel Kumar a écrit :

Hi Bruno,  I just tested on 5.4 for your sake and it works fine.  You are
somewhere goofing up.  Please create a new simple schema different from
your use case with 2-3 fields with 2-3 documents and test this out
independently on your current problem.  That's what i can make suggestion
and did same to confirm this.

On Wed, Jan 6, 2016 at 11:48 AM, Bruno Mannina  wrote:


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  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:
/solr/c1/select?q=fid:34520196=json=true=id,fid,cc*,st=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:
/solr/c2/select?q=fid:34520196=json=true=id,fid,cc*,st=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: (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=json=true=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 
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  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=fid:34520196=json

this request returns only C1 results and if I do:

http://my_adress:my_port
/solr/C2/select?collection=C1,C2=fid:34520196=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