Hello all, I have a SQL statement as below: select min(a.datetime),accname,year from CWLC_PC a group by accname,year; I have tried many times using agg and max but I cannot get the result as the SQL statement. Please help! Thank you.

Try this: { "aggs": { "accname": { "terms": { "field": "accname" }, "aggs": { "year ": { "terms": { "field": "year " }, "aggs" : { "min_date" : { "min" : { "field" : "datetime" } } } }…

Discuss the Elastic Stack

How elasticsearch query should be written for the following SQL statement?

Elastic Stack Elasticsearch

wangqinghuan (Wang) August 23, 2019, 2:59am 10

I am using Kibana 6.1.3.

Visualize aggs min as sub bucket

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.