NOTE: You are looking at documentation for an older release. For the latest information, see the current release documentation.
SQL Access
editSQL Access
editX-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. Experience 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.