Re: Joining across collections with Nested documents

2017-03-03 Thread Walter Underwood
purposes and we have few 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.

RE: Joining across collections with Nested documents

2017-03-03 Thread Preeti Bhat
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) > On Ma

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

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

Joining across collections with Nested documents

2017-03-02 Thread Preeti Bhat
Hi All, I have two collections in solrcloud namely contact and company, they are in same solr instance. Company is relatively simpler document with id, Name, address etc... Coming over to Contact, this has the nested document like below. I would like to get the Company details using the

Re: Joining Across Collections

2017-01-31 Thread nabil Kouici
JOIN Collection2 B on  A.id=B.idWhere  B.Id is NULL; Regards,NKI. De : nabil Kouici <koui...@yahoo.fr.INVALID> À : "solr-user@lucene.apache.org" <solr-user@lucene.apache.org> Envoyé le : Vendredi 20 janvier 2017 14h42 Objet : Re: Joining Across Collections Hi Mikh

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 are not in th

Re: Joining Across Collections

2017-01-20 Thread nabil Kouici
7 9h00 Objet : Re: Joining Across Collections 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 <koui...@yahoo.fr.invalid> wrote: > Hi All, > I'm using  join across collection feature to do an inner join bet

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 something.

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

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

Joining Across Collections

2017-01-18 Thread nabil Kouici
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 collections. For exemple: Collection1 Field1Collection2 Field2 search document from Collection1 where Field1 !=