Translate SQL into Elasticsearch queries
Added in 6.3.0
Translate an SQL search into a search API request containing Query DSL.
It accepts the same request body parameters as the SQL search API, excluding cursor.
Body
Required
-
fetch_size
number The maximum number of rows (or entries) to return in one response.
-
filter
object An Elasticsearch Query DSL (Domain Specific Language) object that defines a query.
-
query
string Required The SQL query to run.
-
time_zone
string
POST
/_sql/translate
curl \
--request POST 'http://api.example.com/_sql/translate' \
--header "Authorization: $API_KEY" \
--header "Content-Type: application/json" \
--data '"{\n \"query\": \"SELECT * FROM library ORDER BY page_count DESC\",\n \"fetch_size\": 10\n}"'
Request example
{
"query": "SELECT * FROM library ORDER BY page_count DESC",
"fetch_size": 10
}