SQL
X-Pack includes a SQL feature to execute SQL queries against Elasticsearch 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.
© 2023-2025 Elasticsearch
As of September 2024, Elasticsearch is available under a choice of three licenses: the Server Side Public License (SSPL), the Elastic License, or the AGPLv3 (OSI approved).
Elasticsearch and the Elasticsearch logo are trademarks of Elasticsearch B.V., registered in the U.S. and in other countries.
https://www.elastic.co/guide/en/elasticsearch/reference/7.17/xpack-sql.html
