RE: Faceting on multivalued field

2011-04-04 Thread Jonathan Rochkind
: Faceting on multivalued field Why not count them on the way in and just store that number along with the original e-mail? Best Erick On Sun, Apr 3, 2011 at 10:10 PM, Kaushik Chakraborty wrote: > Ok. My expectation was since "comment_post_id" is a MultiValued field hence >

Re: Faceting on multivalued field

2011-04-04 Thread Erick Erickson
I hadn't thought that far. But if you can change your query to sum the fields that'd be easiest. Mostly, I was thinking that since that information is known up front, storing it with the document makes sense and would avoid costly Solr work. I don't know of any transformers that would do this for

Re: Faceting on multivalued field

2011-04-04 Thread Kaushik Chakraborty
Are you implying to change the DB query of the nested entity which fetches the comments (query is in my post) or something can be done during the index like using Transformers etc. ? Thanks, Kaushik On Mon, Apr 4, 2011 at 8:07 AM, Erick Erickson wrote: > Why not count them on the way in and jus

Re: Faceting on multivalued field

2011-04-03 Thread Erick Erickson
Why not count them on the way in and just store that number along with the original e-mail? Best Erick On Sun, Apr 3, 2011 at 10:10 PM, Kaushik Chakraborty wrote: > Ok. My expectation was since "comment_post_id" is a MultiValued field hence > it would appear multiple times (i.e. for each comment

Re: Faceting on multivalued field

2011-04-03 Thread Chris Fauerbach
Wouldn't you want to extract your original data format from the index and then 'count' the comments for each post ? I don't think facets are appropriate. On Apr 3, 2011, at 22:10, Kaushik Chakraborty wrote: > Ok. My expectation was since "comment_post_id" is a MultiValued field hence > it wou

Re: Faceting on multivalued field

2011-04-03 Thread Kaushik Chakraborty
Ok. My expectation was since "comment_post_id" is a MultiValued field hence it would appear multiple times (i.e. for each comment). And hence when I would facet with that field it would also give me the count of those many documents where comment_post_id appears. My requirement is getting total fo

Re: Faceting on multivalued field

2011-04-03 Thread Erick Erickson
Hmmm, I think you're misunderstanding faceting. It's counting the number of documents that have a particular value. So if you're faceting on "comment_post_id", there is one and only one document with that value (assuming that the comment_post_ids are unique). Which is what's being reported This