SQL Commands

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

This section contains the list of SQL commands supported by Elasticsearch SQL along with their syntax:

DESCRIBE TABLE
Describe a table.
SELECT
Retrieve rows from zero or more tables.
SHOW COLUMNS
List columns in table.
SHOW FUNCTIONS
List supported functions.
SHOW TABLES
List tables available.