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

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 "Compan