This topic describes the SQL statements that DLA supports.
CREATE SCHEMA: Creates schemas or databases.
CREATE TABLE: Creates tables.
DROP SCHEMA: Deletes schemas or databases.
DROP TABLE: Deletes tables.
SELECT: Performs query.
MSCK REPAIR TABLE: Synchronizes data partitions of data sources in OSS to the metadata.
SHOW SCHEMAS: Queries all schemas in a database.
SHOW TABLES: Queries all tables in the current schema.
SHOW CREATE TABLE: Queries the statement for creating a table.
SHOW PARTITIONS: Lists all partitions in a table.
SHOW QUERY_TASK: Queries the information of query tasks.
GRANT: Authorizes accounts.
REVOKE: Revokes account permissions.