Advanced Elasticsearch 7.0

Elasticsearch SQL query syntax

SELECT is a very powerful statement that can be very simple, but there are also many optional parts that allow you to filter and shape the data you want to solve your complex problems. The complete syntax of the SELECT statement is complicated, but it can be described as follows, similar to what is in SQL:

SELECT select_expr [, ...]
[ FROM table_name [[AS] alias]]
[ WHERE search_condition_1 ]
[ GROUP BY expression [, ...] ]
[ HAVING search_condition_2]
[ ORDER BY order_expression [ ASC | DESC ] [, ...] ]
[ LIMIT [ count ] ]

Elasticsearch only accepts one command at a time in the current stage. Also, it does not support subqueries. Therefore, only table_name (index) is accepted in the FROM clause. To access multiple ...