You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Marek Woroniecki (JIRA)" <ji...@apache.org> on 2012/05/23 11:31:42 UTC
[jira] [Commented] (SOLR-2614) stats with pivot
[ https://issues.apache.org/jira/browse/SOLR-2614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13281478#comment-13281478 ]
Marek Woroniecki commented on SOLR-2614:
----------------------------------------
I would also like to see this feature.
In our app we do a lot of faceting to allow users to drill down into data by selecting particular values per particular fields. We also calculate stats for these selections using stat component. However, quite often we need to group documents into chunks by their common attributes and then calculate stats as well. In classic approach using database we would probably do that with the "group by" phrase and use some aggregating functions. Unfortunately for some reasons this is not an easy option in our case, and we are left with either reading all the documents and calculating grouping in memory, or our users have to extract all the data to csv and do some pivots / stats in excel.
I would be more than happy to implement this patch, if I only knew more about how Lucene / Solr works internally :(
> 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