I have documents such as: { {id:1, timestamp:123456897} , {id:1, timestamp:123456893}, {id:1, timestamp:123356897} } Suppose I need to get highest time stamp for each id ? (assuming there can be multiple ids and each id has multiple timestamps.) SQL query can be: SELECT id, max(timestamp) FR…

How to parse below SQL query to ES?

kedarsdixit (Kedar Dixit) October 4, 2017, 7:55pm 7

thanks @rockybean, I am using java APIs to pull the data, could you please help me in making use of them for above queries ? Thanks!

Convert SQL query to Java Elastic Query

Topic		Replies	Views
Convert SQL query to Java Elastic Query Elasticsearch	2	1994	October 6, 2017
Elasticsearch group by and max on a text field of type Keyword Elasticsearch	2	1055	August 16, 2019
Fetch all documents from index having max(field) <= today's date Elasticsearch	1	370	March 10, 2020
Need help with Elasticsearch query Elasticsearch	9	1238	March 10, 2020
How to translate my sql query into es-sql? Elasticsearch elastic-stack-sql	1	365	August 2, 2022