Hi, I want to achieve some functionality which is available in SQL data stores. I have tried a lot but having a hard time achieving that functionality with elasticsearch. I am successful in creating the queries but the query does not seem to work correctly. I want to do: Group by based on some i…

Here is a very good answer by Nikolay Vasiliev, [Nikolay Vasiliev] SQL like GROUP BY AND HAVING elasticsearch, elasticsearch-5 answered by Nikolay Vasiliev on 12:08PM - 26 Oct 17

Discuss the Elastic Stack

SQL like GROUP BY AND HAVING

Elastic Stack Elasticsearch

danishamjad30 (Danish Amjad) October 30, 2017, 9:29am 2

Here is a very good answer by Nikolay Vasiliev,

2 Likes

Topic		Replies	Views
ElasticSearch Having-Clause? Elasticsearch	2	2908	July 6, 2017
Group by, having sql ..How to Convert Elasticsearch	3	319	September 7, 2021
How to write a query with groupBy, having and orderBy with elastic? Elasticsearch	3	420	November 5, 2018
About elasticsearch DSL Query Elasticsearch	1	355	July 5, 2017
Can ES do a complex aggregation with WHERE and GROUP BY + ORDER BY like in MySQL Elasticsearch	8	1239	March 30, 2021

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

SQL like GROUP BY AND HAVING

Related topics