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

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.