Hello, The short answer is that you need to flatten everything. Your index then has some column-db-like redundancy, but queries become simple and flat.
Buuuuut: See http://blog.sematext.com/2010/06/02/lucene-digest-may-2010-3/ and https://issues.apache.org/jira/browse/LUCENE-2454 in particular. Otis ---- Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch Lucene ecosystem search :: http://search-lucene.com/ ----- Original Message ---- > From: amit_ak <amit...@mindtree.com> > To: solr-user@lucene.apache.org > Sent: Fri, June 18, 2010 6:02:36 AM > Subject: Nested table support ability > > I want to use Solr for free text and parameter based search. I need help > to validate if Solr can help me in achieving following > requirement. Say I have two database tables having one to many > relationships. 1. Customer - Customer Id, Customer Name, Profile 2. Role - > Role Type, Start date, End Date, Customer Id(Foreign key to Customer > table) Start and End date of the role are will decide effectiveness of > the role. Logic for role effectiveness: Current Date > Start Date and > Current Date <= End Date Say I have following records in > tables ---------- Customer Table -------------------- Customer Id > Name Profile 1 > David Some > text : : ---------- Role Table -------------------- Customer > Id Role Type Start date > End Date 1 > ADMIN > 01/01/2000 01/01/2001 > 1 > OPERATOR 01/01/2009 > 01/01/2010 : : If my search criteria is, Get me all > customers playing role of ADMIN as of current date. Expected result - > No customer records should be returned as current date(06/18/2010) is greater > than "End Date" for ADMIN role record. I want to create instance > of “Document” per customer record and want to have nested table relations > embedded in the document. Please help me understand if such a > requirement is possible to achieve in Solr. Thanks in > advance. -- View this message in context: > href="http://lucene.472066.n3.nabble.com/Nested-table-support-ability-tp905253p905253.html"; > > target=_blank > >http://lucene.472066.n3.nabble.com/Nested-table-support-ability-tp905253p905253.html Sent > from the Solr - User mailing list archive at Nabble.com.
