SQL overview
Elastic Cloud Serverless projects are autoscaled environments, fully managed by Elastic and available on Elastic Cloud. Availability This functionality is generally available and ready for production usage. Serverless interfaces and procedures might differ from classic Elastic Stack deployments. The Elastic Stack includes Elastic's core products such as Elasticsearch, Kibana, Logstash, and Beats. Availability This functionality is generally available and ready for production usage. Unless stated otherwise on the page, this functionality is available when your Elastic Stack is deployed on Elastic Cloud Hosted, Elastic Cloud Enterprise, Elastic Cloud on Kubernetes, and self-managed environments. This documentation corresponds to the latest patch available for each minor version. If you're not using the latest patch, check the release notes for changes.
Serverless
Generally available
Stack
Generally available
Elasticsearch SQL aims to provide a powerful yet lightweight SQL interface to Elasticsearch.
Elasticsearch SQL is a feature that allows SQL-like queries to be executed in real-time against Elasticsearch. Whether using the REST interface, command-line or JDBC, any client can use SQL to search and aggregate data natively inside Elasticsearch. One can think of Elasticsearch SQL as a translator, one that understands both SQL and Elasticsearch and makes it easy to read and process data in real-time, at scale by leveraging Elasticsearch capabilities.
- Native integration
- Elasticsearch SQL is built from the ground up for Elasticsearch. Each and every query is efficiently executed against the relevant nodes according to the underlying storage.
- No external parts
- No need for additional hardware, processes, runtimes or libraries to query Elasticsearch; Elasticsearch SQL eliminates extra moving parts by running inside the Elasticsearch cluster.
- Lightweight and efficient
- Elasticsearch SQL does not abstract Elasticsearch and its search capabilities - on the contrary, it embraces and exposes SQL to allow proper full-text search, in real-time, in the same declarative, succinct fashion.
This overview page is in the Explore & Analyze section. All of the Elasticsearch SQL documentation lives in the Reference section.
- 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.