@Bram >SQL-speak GROUP BY and would like to add aggregate functions (SUM, COUNT, ..). Yes that is close.
> SOLR-5302 and SOLR-3583 I will look closer at them. @Steve I will take a look at this patch, on the surface it seems like it may meet the first need. On Tue, Oct 22, 2013 at 6:07 AM, Steve Molloy <[email protected]> wrote: > 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] > >
