Data Lake Compute
- Getting Started
- Operation Guide
- Console Operation Introduction
- Data Development and Exploration
- Data Exploration
- Data Query Task
- Resource Management
- Engine Management
- SuperSQL Engine
- Standard Engine
- Resource Group
- Private Connection
- Storage Configuration
- Ops Management
- Insight Management
- System Management
- User and Permission Management
- Monitoring and Alarms
- Development Guide
- System Restraints
- Client Access
- JDBC Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Unified Statement
- DDL Statement
- ALTER TABLE
- DML Statement
- DQL Statement
- Iceberg Table Statement
- API Documentation
- Making API Requests
- Data Table APIs
- Task APIs
- Metadata APIs
- Service Configuration APIs
- Permission Management APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- General Reference
- Operation Guide on Connecting Third-Party Software to DLC
Overview of SuperSQL Statement
Last updated: 2024-10-30 17:25:33
DLC can run almost seamlessly on the DLC Serverless Spark and DLC Serverless Presto engines through a set of standard SQL statements. Statements and functions related to metadata and analysis are basically compatible with Hive and Spark statements, and custom functions are supported.
For supported system built-in functions, see Unified Functions. If you need to use Presto built-in functions, see Presto Built-in Functions.
If you need to query and analyze data in external Iceberg tables on DLC, some statements may differ from those for native tables. For details, see Iceberg External Tables vs. Native Tables Statement Differences.
The following table lists statements supported by DLC:
DDL Statements
Database-Related Statements
Purpose | Statement |
Create a database. | |
Display all databases defined in this metadata. | |
View database attributes. | |
Change database attributes. | |
Change database storage location. | |
Delete a database. | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Data Table-Related Statements
Purpose | Statement |
Create a data table. | |
Update table snapshot. | |
Query data table creation statements. | |
Query table attributes. | |
Query all tables in database. | |
View column information and metadata information on the data table. | |
Query column information on the data table. | |
Add a column to the data table. | |
Add a column to the data table. | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Chang a field name. | |
Delete a field in the data table. | |
Add a partition to the data table. | |
List table partitions. | |
Delete a partition of the data table. | |
Add a partition field to the Iceberg table. | |
Delete a partition field of the Iceberg table. | |
Change data table attributes. | |
Change data table storage location. | |
Change the sorting method of data in the table. | |
Change data distribution policy of partitioned table. | |
Add identifier fields attribute. | |
| |
Delete identifier fields attribute. | |
Update partition information. | |
Perform statistics on data table. | |
Delete metadata table. | |
Display logical or physical plan for executing SQL statements. | |
Call table-related stored procedure. | |
Statements Related to View
Purpose | Statement |
Create a view based on results of SELECT statement. | |
Query view in the database. | |
Check view attributes. | |
Display view creation statements. | |
Check view columns. | |
Change view name. | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Change view attributes. | |
Delete view. | |
Statements Related to Function
Purpose | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Create a function. | |
| |
| |
View function creation statements | |
Delete a function. | |
DML Statements
Purpose | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Insert a row of data. | |
| |
Replace a row of data. | |
Update data by row (for replacing INSERT OVERWRITE). | |
Query Iceberg table metadata. | |
Insert query results to the data table. | |
| |
Delete data of Iceberg table. | |
Update the specified row. | |
DQL Statement
Purpose | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
Query data. | |
| |
| |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No