SQL Commandsedit

This functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview 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.