Translates an SQL search into a search API request containing Query DSL. See SQL Translate API.
POST _sql/translate
{
"query": "SELECT * FROM library ORDER BY page_count DESC",
"fetch_size": 10
}
-
If the Elasticsearch security features are enabled, you must have the
readindex privilege for the data stream, index, or alias you search.
See SQL Limitations.
The SQL translate API accepts the same request body parameters as the
SQL search API, excluding cursor.
The SQL translate API returns the same response body as the search API.