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
Equivalent to SQL window functions Elasticsearch	9	7034	November 4, 2022
Elasticsearch: aggregation and select docs only having max value of field Elasticsearch	3	2846	August 28, 2019
How to get max value with document data Elasticsearch	4	7584	July 5, 2017
How to get the max timestamp of an elastic search index? Elasticsearch	4	5810	June 25, 2018
Query by max date Elasticsearch	1	2309	November 5, 2020