Re: Joining across collections with Nested documents

2017-03-03 Thread Walter Underwood
cases > where we would need data from both. > > > Thanks and Regards, > Preeti Bhat > > -Original Message- > From: Walter Underwood [mailto:wun...@wunderwood.org] > Sent: Friday, March 03, 2017 12:02 PM > To: solr-user@lucene.apache.org > Subject: Re: J

RE: Joining across collections with Nested documents

2017-03-03 Thread Preeti Bhat
Thanks Mikhail, I will look into this option. Thanks and Regards, Preeti Bhat -Original Message- From: Mikhail Khludnev [mailto:m...@apache.org] Sent: Friday, March 03, 2017 1:03 PM To: solr-user Subject: Re: Joining across collections with Nested documents Related docs can be

RE: Joining across collections with Nested documents

2017-03-03 Thread Preeti Bhat
e.org Subject: Re: Joining across collections with Nested documents Make one collection with denormalized data. This looks like a relational, multi-table schema in Solr. That will be slow and painful. wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ (my blog) >

Re: Joining across collections with Nested documents

2017-03-02 Thread Mikhail Khludnev
Related docs can be retrieved with https://cwiki.apache.org/confluence/display/solr/Transforming+Result+Documents#TransformingResultDocuments-[subquery] but searching related docs is less ready. Here is a patch for query time join across collections https://issues.apache.org/jira/browse/SOLR-8297.

Re: Joining across collections with Nested documents

2017-03-02 Thread Walter Underwood
Make one collection with denormalized data. This looks like a relational, multi-table schema in Solr. That will be slow and painful. wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ (my blog) > On Mar 2, 2017, at 9:55 PM, Preeti Bhat wrote: > > Hi All, > > I hav

Re: Joining Across Collections

2017-01-31 Thread nabil Kouici
LEFT OUTER JOIN Collection2 B on  A.id=B.idWhere  B.Id is NULL; Regards,NKI. De : nabil Kouici À : "solr-user@lucene.apache.org" Envoyé le : Vendredi 20 janvier 2017 14h42 Objet : Re: Joining Across Collections Hi Mikhail, I'm not we can do a negation because Field1 and F

RE: Joining Across Collections

2017-01-20 Thread Moenieb Davids
23", { Regards Moenieb Davids -----Original Message- From: nabil Kouici [mailto:koui...@yahoo.fr.INVALID] Sent: 20 January 2017 03:43 PM To: solr-user@lucene.apache.org Subject: Re: Joining Across Collections Hi Mikhail, I'm not we can do a negation because Field1 and Field2 a

Re: Joining Across Collections

2017-01-20 Thread nabil Kouici
Hi Mikhail, I'm not we can do a negation because Field1 and Field2 are not in the join condition. Regards,Nabil. De : Mikhail Khludnev À : solr-user ; nabil Kouici Envoyé le : Jeudi 19 janvier 2017 9h00 Objet : Re: Joining Across Collections It seems like it can be done by

RE: Joining Across Collections

2017-01-19 Thread Moenieb Davids
{ Regards Moenieb Davids -Original Message- From: Mikhail Khludnev [mailto:m...@apache.org] Sent: 19 January 2017 10:00 AM To: solr-user; nabil Kouici Subject: Re: Joining Across Collections It seems like it can be done by just negating join query or I'm missing someth

Re: Joining Across Collections

2017-01-19 Thread Mikhail Khludnev
It seems like it can be done by just negating join query or I'm missing something. On Wed, Jan 18, 2017 at 11:32 AM, nabil Kouici wrote: > Hi All, > I'm using join across collection feature to do an inner join between 2 > collections. It works fine. > Is it possible to use this feature to compa

Re: Joining Across Collections

2017-01-18 Thread billnbell
Great question Bill Bell Sent from mobile > On Jan 18, 2017, at 1:32 AM, nabil Kouici wrote: > > Hi All, > I'm using join across collection feature to do an inner join between 2 > collections. It works fine. > Is it possible to use this feature to compare between fields from different > co