You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Vivekanand Ittigi <vi...@biginfolabs.com> on 2014/06/13 12:06:18 UTC

SUM and groupBy in solr

Hi,

How to execute this query:

select SUM(Primary_cause_vaR),
RiskType,market from bil_tos Where skuType='Product' group by
RiskType,market;

I've used http://wiki.apache.org/solr/StatsComponent for this:

* I see only sum with respective groupBy fields but i want to see RiskType,
market fields also in the result

Thanks,
Vivek