FYI,
If denormalization doesn't work for you, check index time join
http://blog.mikemccandless.com/2012/01/searching-relational-content-with.html.
here is the scratch for query and index time support:
https://issues.apache.org/jira/browse/SOLR-3076
https://issues.apache.org/jira/browse/SOLR-3535
Sorry you have that link! and I did not see the question - apols
index schema could look something like:
id
name
classList -> multi value
majorClassList -> multi value
a standard query would do the equivalent of your sql
again apols for not seeing the link
lee c
On 27 June 2012 12:37, Lee C
The point is sometimes data after de-normalization will be huge, in some case,
it's even impossible.
Thanks,
-Original Message-
From: Lee Carroll [mailto:lee.a.carr...@googlemail.com]
Sent: Wednesday, June 27, 2012 7:38 PM
To: solr-user@lucene.apache.org
Subject: Re: how Solr/Lucen
In your example de-normalising would be fine in a vast number of
use-cases. multi value fields are fine.
If you really want to, see http://wiki.apache.org/solr/Join but make
sure you loose the default relational dba world view first
and only go down that route if you need to.
On 27 June 2012 12
