Have a look at SOLR-4212, it seems to fit your first point. Steve
-----Original Message----- From: Bram Van Dam [mailto:[email protected]] Sent: October-22-13 8:41 AM To: [email protected] Subject: Re: Pivot Faceting with distinct counts On 10/22/2013 02:25 PM, Andrew Psaltis wrote: > 1. Getting distinct counts for a field other than the one being faceted on. > 2. How would I get this field to surface in the response. If I'm understanding you correctly, you're using pivots as SQL-speak GROUP BY and would like to add aggregate functions (SUM, COUNT, ..). This is currently not possible. The way we accomplish this is by relying on the StatsComponent and its one-dimensional faceting (thankfully we only need sums ..). This is tedious and slow, as it requires many queries instead of (ideally) 1 query. SOLR-5302 is probably your best bet. The people working on SOLR-3583 might be able to have a few things to say about this as well. I will say this: the faceting code is pretty scary. Adding support for (what is essentially) multi-dimensional pivoting with aggregation is a pretty big challenge. My original plan was to start work on this myself, but time constraints do not permit that. We would probably be able and willing to sponsor someone to work on this. - Bram --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
