This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.
SQL
editSQL
editElasticsearch includes a SQL feature to execute SQL queries against indices and return results in tabular format.
The following chapters aim to cover everything from usage, to syntax and drivers. Experienced users or those in a hurry might want to jump directly to the list of SQL commands and functions.
- Overview
- Overview of Elasticsearch SQL and its features.
- Getting Started
- Start using SQL right away in Elasticsearch.
- Concepts and Terminology
- Language conventions across SQL and Elasticsearch.
- Security
- Secure Elasticsearch SQL and Elasticsearch.
- REST API
- Execute SQL in JSON format over REST.
- Translate API
- Translate SQL in JSON format to Elasticsearch native query.
- CLI
- Command-line application for executing SQL against Elasticsearch.
- JDBC
- JDBC driver for Elasticsearch.
- ODBC
- ODBC driver for Elasticsearch.
- Client Applications
- Setup various SQL/BI tools with Elasticsearch SQL.
- SQL Language
- Overview of the Elasticsearch SQL language, such as supported data types, commands and syntax.
- Functions and Operators
- List of functions and operators supported.
- Limitations
- Elasticsearch SQL current limitations.