lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marek Woroniecki (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SOLR-2614) stats with pivot
Date Wed, 23 May 2012 09:31:42 GMT

    [ 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


Mime
View raw message