I'm trying perform an elasticsearch query as a GET request in order pull data from the index which I created. The data which is in the index is, a table from MySQL DB, configured though logstash. Here is my request without the IN clause: http://localhost:9200/response_summary/_search?q=api:"locati…

How could I have MySQL sum() and group by clause within my elasticsearch query?

nik9000 (Nik Everett) September 29, 2016, 6:37pm 2

Have a look at aggregations, in particular the terms and sum aggregations.

1 Like

Topic		Replies	Views
How can I have both sum and groupby in a single aggregation Elasticsearch? Elasticsearch	1	508	July 5, 2017
How to perform sql group by and sum query in elasticsearch Elasticsearch	1	689	December 11, 2017
Elasticsearch Aggregation question Elasticsearch	2	344	June 14, 2019
Can ES do a complex aggregation with WHERE and GROUP BY + ORDER BY like in MySQL Elasticsearch	8	1248	March 30, 2021
Mysql where clause and group by Help Elasticsearch	1	477	July 6, 2017