Is it possible to do this in one search: select count(1), sum(field1) from table where condition group by field2

makeyang · September 11, 2015, 2:02am

without count(1), it is sample, but is it possible if with count and do it in one search?

nik9000 · September 11, 2015, 12:36pm

See aggregations. They do exactly this.

Topic		Replies	Views
How to use Executing Aggregations group by with one condition? Elasticsearch	1	568	July 5, 2017
Get distinct count on a field by grouping on another field and select all rows with a condition on that count Elasticsearch	1	488	April 10, 2020
Elastic search aggregation similar to group by Elasticsearch	2	714	September 21, 2018
Can elasticsearch do GROUP BY multi fields and ORDER BY count? Elasticsearch	3	26422	May 9, 2019
elasticsearch-DSL aggregation of part of query result. like select * from (select * from table limit 100) Elasticsearch	1	384	December 3, 2018