You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Trey Grainger (JIRA)" <ji...@apache.org> on 2012/06/12 03:23:43 UTC
[jira] [Comment Edited] (SOLR-2614) stats with pivot
[ https://issues.apache.org/jira/browse/SOLR-2614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13293249#comment-13293249 ]
Trey Grainger edited comment on SOLR-2614 at 6/12/12 1:23 AM:
--------------------------------------------------------------
Hi Terrance,
We (at CareerBuilder) 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
CareerBuilder
was (Author: solrtrey):
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
CareerBuilder
> stats with pivot
> ----------------
>
> Key: SOLR-2614
> URL: https://issues.apache.org/jira/browse/SOLR-2614
> 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org