How to sum up values in Solr4.10.3

Asked May 16 '19 at 07:57

Active May 16 '19 at 08:48

Viewed 28 times

I installed Solr from CDH which version is 4.10.3-cdh5.13.0. My job like one sql work like,How to realize by Solr4:

select D,E,sum(A),sum(B) from DOC where C='balabala' group by D , E;

I try this one,but only one column in group section.

&stats=on
&stats.field=A
&stats.field=B
&stats.facet=D

In Solr5,code below works,but in Solr4 failed:

facet=true&stats=true&stats.field={!tag=piv1}A&facet.pivot={!stats=piv1}D,E

Is there one approach ? and one more question: how to realize

select D,E,sum(A*B) from DOC where C='balabala' group by D , E;

edited May 16 '19 at 08:48

asked May 16 '19 at 07:57

Fire

You are on Cloudera Search right ? What do you mean by `sum(A)`, `sum(B)` & `sum(A*B)` ? Are A and B multivalued fields ? – EricLavault May 16 '19 at 08:08
`group by D and E`? In SQL you'd do `group by D, E`. – jarlh May 16 '19 at 08:25
@EricLavault, i.e A is price ,B is count, single value field. – Fire May 16 '19 at 08:47

0 Answers0