lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trey Grainger (JIRA)" <>
Subject [jira] [Commented] (SOLR-2614) stats with pivot
Date Tue, 12 Jun 2012 01:23:43 GMT


Trey Grainger commented on SOLR-2614:

Hi Terrance,

We (at CareerBuilder) recently built a patch recently which could serve as a good starting
point for this.  We build an ability to calculate Percentiles (i.e. 25th, 50th, etc.) and
Averages using multi-level (distributed) Pivot Facets.  It works well enough for our use cases,
and I'm sure the stats types mentioned could be added in.

It is dependent upon the distributed pivot faceting patch (SOLR-2894), which seem to be working
well but has yet to be committed.

I'll see if we can get the patch posted either as part of this JIRA or separately in the next
day or so, which could save you some time in implementing the other types.

-Trey Grainger
> stats with pivot
> ----------------
>                 Key: SOLR-2614
>                 URL:
>             Project: Solr
>          Issue Type: Improvement
>          Components: SearchComponents - other
>    Affects Versions: 4.0
>            Reporter: pengyao
>            Priority: Critical
>             Fix For: 4.1
>  Is it possible to get stats (like Stats Component: min ,max, sum, count,
> missing, sumOfSquares, mean and stddev) from numeric fields inside
> hierarchical facets (with more than one level, like Pivot)?
>  I would like to query:
> ...?q=*:*&version=2.2&start=0&rows=0&stats=true&stats.field=numeric_field1&stats.field=numeric_field2&stats.pivot=field_x,field_y,field_z
>  and get min, max, sum, count, etc. from numeric_field1 and
> numeric_field2 from all combinations of field_x, field_y and field_z
> (hierarchical values).
>  Using stats.facet I get just one field at one level and using
> facet.pivot I get just counts, but no stats.
>  Looping in client application to do all combinations of facets values
> will be to slow because there is a lot of combinations.
>  Thanks a lot!
> this  is  very  import,because  only counts value,it's no use for sometimes.
> please add   stats with pivot  in solr 4.0 
> thanks a lot

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message