SQL
Elasticsearch's SQL APIs enable you to run SQL queries on Elasticsearch indices and data streams.
-
Get SQL search results
Stack
6.3+
- POST also GET /_sql
-
Delete an async SQL search
Stack
7.15+
- DELETE /_sql/async/delete/{id}
-
Get the async SQL search status
Stack
7.15+
- GET /_sql/async/status/{id}
-
Get async SQL search results
Stack
7.15+
- GET /_sql/async/{id}
-
Clear an SQL search cursor
Stack
6.3+
- POST /_sql/close
-
Translate SQL into Elasticsearch queries
Stack
6.3+
- POST also GET /_sql/translate