Hi every one, I would like to query the data by using the concept in SQL "Group by" like below "SELECT user, DATE(timestamp), EXTRACT(HOUR FROM timestamp), floor_name FROM location WHERE DATE(timestamp) BETWEEN "(d1) " AND "(d2) " GROUP BY DATEtimestamp), EXTRACT(HOUR FROM timestamp), user, floo…

How to get the data with concept in SQL "Group by"

matriv (Marios Trivyzas) April 20, 2021, 7:48am 2

The SQL Group By queries are translated to composite aggregations. You could use the translate SQL endpoint to see how your SQL query translates to ES query DSL.

1 Like

Topic		Replies	Views
About elasticsearch DSL Query Elasticsearch	1	355	July 5, 2017
Group By Counts Elasticsearch	2	233	July 6, 2017
Group by clause Elasticsearch	2	319	July 6, 2017
Can ES do a complex aggregation with WHERE and GROUP BY + ORDER BY like in MySQL Elasticsearch	8	1241	March 30, 2021
Grouping by non-numeric field Elasticsearch	2	282	July 6, 2017