SQL Access

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. 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.