select tag1, tag2, sum(sum_val) select tag-uid, sum(value) as sum_val from data_table group by tag-uid join tag_table using(tag-uid) group by tag1, tag2

How to write a efficient ES query for the below SQL query?

aravindputrevu (Aravind Putrevu) January 19, 2020, 6:47am 2

If you have your documents ingested appropriately like mentioned here, you could use the translate endpoint of Elasticsearch SQL and convert the SQL query to equivalent Query DSL.

--
Aravind

Can ES not to store original keyword content but a mapping num value (4 save space)?

Topic		Replies	Views
Need help with Sum Elasticsearch	4	303	July 6, 2017
How to perform sql group by and sum query in elasticsearch Elasticsearch	1	675	December 11, 2017
Need help in writing aggregate query Elasticsearch language-clients	3	32	September 30, 2024
SQL column alias equivalent in Elasticsearch query Elasticsearch kql-kibana-query-language , eql-elastic-query-language	1	610	April 29, 2022
How to parse below SQL query to ES? Elasticsearch	10	2830	November 6, 2017

How to write a efficient ES query for the below SQL query?

Related topics