All Products
Search
Document Center

Common SQL statements

Last Updated: Mar 22, 2021

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.

  • DDL

    • 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

  • DML

  • ACL

    • GRANT: grants permissions to accounts.

    • REVOKE: revokes the granted permissions.