not that I know of. Also, your performance will be much better if you can denormlized the data.
On Mon, Dec 3, 2012 at 12:44 AM, Vikash Sharma <vikash0...@gmail.com> wrote: > Hi Erick, > One more thing: So is there any other way to get the result? > I mean, I need to get both parent and child document in/not nested format. > > Regards, > Vikash > > Regards, > Vikash Sharma > vikash0...@gmail.com > > > On Sat, Dec 1, 2012 at 10:29 PM, Erick Erickson <erickerick...@gmail.com > >wrote: > > > That's the way joins work, and why they're called "pseudo join", they > don't > > work like DB joins and return data from both records.... > > > > Joins were put in for a specific use-case, when you try to treat Solr > like > > a DB you're bound to be disappointed. I'd think about reworking the > > solution to de-normalize the data so you don't have to do joins. > > > > Best > > Erick > > > > > > On Fri, Nov 30, 2012 at 10:38 AM, Vikash Sharma <vikash0...@gmail.com > > >wrote: > > > > > Hi All, > > > I have my field definition in schema.xml like below > > > > > > <field name="id" type="string" indexed="true"..... /> > > > <field name="Emp_id" type="string" indexed="true"..... /> > > > <field name="doc_id" type="string" indexed="true"..... /> > > > <field name="content" type="string" indexed="true"..... /> > > > > > > > > > I need to create separate record in solr for each parent child > > > relationship... such that if child is same across different parent that > > it > > > gets stored only once. > > > > > > For e.g. > > > -----------_Record 1 > > > <id>ABC<id/> > > > <emp_id>EMP001<emp_id/> > > > <doc_id>DOC001<doc_id/> > > > <doc_content>My Parent Doc<doc_content/> > > > > > > -----------_Record 2 > > > <id>DOC001<id/> > > > <emp_id><emp_id/> > > > <doc_id><doc_id/> > > > <doc_content>My Document Data<doc_content/> > > > > > > > > > This will ensure that if any doc_id content is duplicate, than only > once > > > the record is inserted in the solr. > > > > > > Lastly, I want the result as join. if emp_id=EMP001. then both record > > > should be returned, as there is a relationship between two records > using > > of > > > doc_id = id > > > > > > If I query: > > > > > > > > > http://localhost:8983/solr/select?q={!join%20from=doc_id%20to=id}emp_id:EMP001&wt=json > > > < > > > > > > http://localhost:8983/solr/select?q={!join%20from=sha_one%20to=id}project_id:10&wt=json > > > > > > > > > > I expect both record should be returned either one after another or > > > nested.. > > > But I only get child records... > > > > > > > > > Please help.. > > > > > > > > > > > > Regards, > > > Vikash Sharma > > > vikash0...@gmail.com > > > > > >