This topic describes common SQL statements supported by Data Lake Analytics (DLA).
DLA Presto is developed based on Presto. The DDL statements of DLA are Hive-compatible, and the DML statements support the ANSI SQL syntax.
Common DDL statements
Metadata-related statements if the data source is OSS
Metadata-related statements if the data source is a database
Common query DDL statements
SHOW SCHEMAS: queries all the schemas or databases of a specific user.
SHOW TABLES: queries tables in the current schema.
SHOW CREATE TABLE: views the CREATE TABLE statement.
SHOW PARTITIONS: shows information about all the partitions in a table.
SHOW QUERY_TASK: queries the query task information of a specific user.