Re: Solr 4.x union of cross-joins

2013-07-08 Thread mihaela olteanu
93ventilation testChild2 103ventilation testChild2 Thanks Mihaela From: mihaela olteanu To: Yonik Seeley Cc: "solr-user@lucene.apache.org" Sent: Monday, July 8, 2013 3:52 PM Subject: Re: Solr 4.x union of cross-joins Here is exactly the data that I

Re: Solr 4.x union of cross-joins

2013-07-08 Thread mihaela olteanu
for each individual piece from the query (one _query_ when querying the parent and one _query_ for each different join query). Unfortunately when using _query_ I cannot write "exact match" queries because I cannot add the query string in " (quotes) (I already add quotes for t

Re: Solr 4.x union of cross-joins

2013-07-06 Thread Yonik Seeley
On Sat, Jul 6, 2013 at 2:22 PM, mihaela olteanu wrote: > Hello, > > I have 3 indices that form a hierarchy. Basically these were constructed from > 3 tables: parent, child1 and child2 and between parent and children there is > a one to many relationship. > parent (id,name) > > child1(id,join_key

Re: Solr 4.x union of cross-joins

2013-07-06 Thread Walter Underwood
If you flatten this to make a single table with rows for each combination of parent, child1, and child2, the query will be simple and probably very fast. You've said it makes more sense to have three tables, and that is true for a relational database. For a search engine, like Solr, it makes mor

Solr 4.x union of cross-joins

2013-07-06 Thread mihaela olteanu
Hello, I have 3 indices that form a hierarchy. Basically these were constructed from 3 tables: parent, child1 and child2 and between parent and children there is a one to many relationship. parent (id,name) child1(id,join_key,field1)  child2(id,join_key,field2)  "join_key" is the foreign key