JOIN in Solr (was: convert custom facets to Solr facets...)

2007-02-03 Thread Brian Whitman
On Feb 2, 2007, at 4:46 PM, Ryan McKinley wrote: I would LOVE to see a JOIN in SOLR. I have an index of artists, albums, and songs. The artists have lots of metadata and the songs very little. I'd love to be able to search for songs using the artist metadata. Right now, I have to add all

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

2007-02-03 Thread Walter Underwood
We would never use JOIN. We denormalize for speed. Not a big deal. wunder == Search Guru, Netflix On 2/3/07 11:16 AM, Brian Whitman [EMAIL PROTECTED] wrote: On Feb 2, 2007, at 4:46 PM, Ryan McKinley wrote: I would LOVE to see a JOIN in SOLR. I have an index of artists, albums, and

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

2007-02-03 Thread Ryan McKinley
On 2/3/07, Walter Underwood [EMAIL PROTECTED] wrote: We would never use JOIN. We denormalize for speed. Not a big deal. I'm looking at an application where speed is not the only concern. If I can remove the need for a 'normalized' and 'denormalized' form it would be a HUGE win. Essentially

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

2007-02-03 Thread Ryan McKinley
oops!!! I meant to reply directly to Brian - an old friend of mine from graduate school... next time I'll check the reply-to button more closely.

Re: JOIN in Solr (was: convert custom facets to Solr facets...)

2007-02-03 Thread Erik Hatcher
I'm quite open to NOT having a JOIN in Solr if flattening the model still provides the querying capability desired. I've not fully followed the specifics that Yonik has mentioned on this thread, but it certainly is the case that denormalizing/flattening our domain does not exactly lend