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 <preeti.b...@shoregrp.com> wrote: > > 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 "CompanyId" field in > child document by joining this to the "Company" collections's id document. > Is this possible? Could someone please guide me on this? > > { > id: "1" > , FirstName: "ABC" > , LastName: "BCD" > . > . > . > _childDocuments_:{ > { > id:"123-1", > CompanyId: "123", > Email: "abc....@smd.edu" > } > { > id:"124-1", > CompanyId: "124", > Email: "abc....@smd.edu" > > } > } > > > > Thanks and Regards, > Preeti Bhat > > > > NOTICE TO RECIPIENTS: This communication may contain confidential and/or > privileged information. If you are not the intended recipient (or have > received this communication in error) please notify the sender and > it-supp...@shoregrp.com immediately, and destroy this communication. Any > unauthorized copying, disclosure or distribution of the material in this > communication is strictly forbidden. Any views or opinions presented in this > email are solely those of the author and do not necessarily represent those > of the company. Finally, the recipient should check this email and any > attachments for the presence of viruses. The company accepts no liability for > any damage caused by any virus transmitted by this email. > >