The content of this page has been automatically translated by AI. If you encounter any problems while reading, you can view the corresponding content in Chinese.
Help & Documentation>Data Lake Compute>SQL Syntax>SuperSQL Syntax>SuperSQL Syntax Overview

SuperSQL Syntax Overview

Last updated: 2026-05-20 17:53:39

On this page:

DLC can run almost seamlessly on both DLC Serverless Spark and DLC Serverless Presto engines using a standard set of SQL syntax. Its metadata, analytical syntax, and functions are largely compatible with Hive and Spark syntax, and custom functions are supported. For the scope of system built-in functions, refer to Unified Functions. To use Presto built-in functions, see Presto Built-in Functions for usage and supported scope. If you need to query and analyze data from external Iceberg tables in DLC, note that some syntax differs from that for native tables. For details, see Syntax Differences Between Iceberg External Tables and Native Tables.
}

DDL Syntax

Database-Related Syntax

Purpose
Syntax
Creating a database
Displaying all databases defined in the metadata.
Viewing database properties
Modifying database properties
Changing database storage location
Delete a database.

Data Table-Related Syntax

Purpose
Syntax
Creating a data table
Updating a table snapshot
Querying data table creation information
Querying table properties
Querying all tables in a database
Viewing data table column information and metadata
Querying data table column information
Adding columns to a data table
Adding a new column to a data table
Renaming a field
Dropping a column from a data table
Adding partition information to a data table
Listing table partitions
Dropping partition information from a data table
Adding a partition field to an Iceberg table
Dropping a partition field from an Iceberg table
Modifying data table properties
Changing data table storage location
Modifying the sort order of table data
Modifying the distribution policy for a partitioned table
Adding identifier fields property
Dropping identifier fields property
Updating partition information
Analyzing a data table
Dropping a metadata table
Displaying the logical or physical plan for executing an sql statement
Calling a table stored procedure

View-Related Syntax

Purpose
Syntax
Creating a view from a select result
Querying views in a database
Viewing view column information
Displaying the view creation statement
Viewing view column information
Renaming a view
Modifying view properties
Deleting a View

Function-Related Syntax

Purpose
Creating a Function
Viewing the Syntax for Creating a Function
Deleting a Function

DML Syntax

Purpose
Inserting a row of data
Replacing a row of data
Row-level data update operation, which can be used to replace the INSERT OVERWRITE operation.
Querying Iceberg table metadata
Inserting query results into a data table.
Deleting data from an Iceberg table.
Updating specified rows

DQL Syntax

Purpose
Data query
For related query reserved words, see Reserved Words.

中国站 - English