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