Hi Solr Group, Got an interesting use case (to me, at least), perhaps someone could give some insight on how best to achieve this?
I've got a core that has about 7million entries, with a field call 'addr'. By definition, every entry has a unique 'addr' value, so there are 7million unique values for this field. I then have another core with ~20million entries. These have a field called 'dest', and there may be, say around 800-1000 unique values for 'dest', but there's always a value - the number of unique values varies. So..the problem is this: What is the best/only/most efficient way to consutruct a search where by I get back an (ideally faceted) list of values for 'dest' that occur in 'addr'? Can I do this with just faceting (e.g. facet query or similar)? Or do I need grouping? Note, I don't actually need the documents themselves, only the list of unique values that are the intersection of 'dest' and 'addr'. Can anyone help shed some light on how best to do this? Many thanks, Peter
