SQL Commandsedit

This functionality is experimental and may be changed or removed completely in a future release. Elastic will take a best effort approach to fix any issues, but experimental 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.