I am using Transport client to query ES. Need to convert below sql query to Java Queries: SELECT id,max(timestamp2) FROM table GROUP BY id AVING timestamp1 > "2017-07-13T21:01:00.013Z" I know TermsQueryBuilder and AggregationBuilder can be used for this one. But I am unable to get it right can so…

Convert SQL query to Java Elastic Query

warkolm (Mark Walkom) October 6, 2017, 9:47pm 2

Given you already have another thread with a bunch of people helping, it's going to be easier to continue the discussion there, as it also has a bit more context

Topic		Replies	Views
How to parse below SQL query to ES? Elasticsearch	10	2830	November 6, 2017
SQL query to elasticSearch query? Elasticsearch	1	1142	July 5, 2017
SQL to ES Query Elasticsearch	3	327	May 18, 2018
Looking for java implementation Elasticsearch	4	347	September 14, 2018
Can ElastiSearch handle such query? Elasticsearch	1	346	July 5, 2017

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.

Convert SQL query to Java Elastic Query

Related topics