Limitations

The select literal expression is not supported. For example, is not supported.

The WHERE clause does not support expressions. For example, SELECT FlightNum FROM opensearch_dashboards_sample_data_flights where (AvgTicketPrice + 100) <= 1000 is not supported.

You can only apply aggregation on fields, aggregations can’t accept an expression as a parameter. For example, avg(log(age)) is not supported.

Then, the query fails because of the field mapping conflict. The query SELECT * FROM conflict_index* also fails for the same reason.

Subquery in the FROM clause in this format: SELECT outer FROM (SELECT inner) is supported only when the query is merged into one query. For example, the following query is supported:

But, if the outer query has or ORDER BY, then it’s not supported.

The pagination query enables you to get back paginated responses. Currently, the pagination only supports basic queries. For example, the following query returns the data with cursor id.

The response in JDBC format with cursor id.

The query with and join does not support pagination for now.