Overview of SuperSQL Statement

Recent Pages

Overview of SuperSQL Statement

Last updated: 2024-08-07 17:09:16

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.
﻿CREATE DATABASE﻿
Display all databases defined in this metadata.
﻿SHOW DATABASES﻿
View database attributes.
﻿DESCRIBE DATABASE﻿
Change database attributes.
﻿ALTER DATABASE SET DBPROPERTIES﻿
Change database storage location.
﻿ALTER DATABASE SET LOCATION﻿
Delete a database.
﻿DROP DATABASE﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
Data Table-Related Statements
Purpose
Statement
Create a data table.
﻿CREATE TABLE﻿
Update table snapshot.
﻿REPLACE TABLE AS SELECT﻿
Query data table creation statements.
﻿SHOW CREATE TABLE﻿
Query table attributes.
﻿SHOW TBLPROPERTIES﻿
Query all tables in database.
﻿SHOW TABLES﻿
View column information and metadata information on the data table.
﻿DESCRIBE TABLE﻿
Query column information on the data table.
﻿SHOW COLUMNS IN TABLE﻿
Add a column to the data table.
﻿ALTER TABLE ADD COLUMNS﻿
Add a column to the data table.
﻿ALTER TABLE ADD COLUMN AFTER/FIRST﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
Chang a field name.
﻿ALTER TABLE ... RENAME COLUMN﻿
Delete a field in the data table.
﻿ALTER TABLE DROP COLUMN﻿
Add a partition to the data table.
﻿ALTER TABLE ADD PARTATION﻿
List table partitions.
﻿SHOW PARTITIONS﻿
Delete a partition of the data table.
﻿ALTER TABLE DROP PARTITION﻿
Add a partition field to the Iceberg table.
﻿ALTER TABLE ADD PARTITION FIELD﻿
Delete a partition field of the Iceberg table.
﻿ALTER TABLE DROP PARTITION FIELD﻿
Change data table attributes.
﻿ALTER TABLE SET TBLPROPERTIES﻿
Change data table storage location.
﻿ALTER TABLE SET LOCATION﻿
Change the sorting method of data in the table.
﻿ALTER TABLE ... WRITE ORDERED BY﻿
Change data distribution policy of partitioned table.
﻿ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION﻿
Add identifier fields attribute.
﻿ALTER TABLE ... SET IDENTIFIER FIELDS﻿
﻿
﻿
Delete identifier fields attribute.
﻿ALTER TABLE ... DROP IDENTIFIER FIELDS﻿
Update partition information.
﻿MSCK REPAIR TABLE﻿
Perform statistics on data table.
﻿ANALYZE TABLES﻿
Delete metadata table.
﻿DROP TABLE﻿
Display logical or physical plan for executing SQL statements.
﻿EXPLAIN﻿
Call table-related stored procedure.
﻿CALL STATEMENT﻿
Statements Related to View
Purpose
Statement
Create a view based on results of SELECT statement.
﻿CREATE VIEW AS﻿
Query view in the database.
﻿SHOW VIEWS﻿
Check view attributes.
﻿DESCRIBE VIEW﻿
Display view creation statements.
﻿SHOW CREATE VIEW﻿
Check view columns.
﻿SHOW COLUMNS IN VIEW﻿
Change view name.
﻿ALTER VIEW RENAME TO﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
Change view attributes.
﻿ALTER VIEW SET TBLPROPERTIES﻿
Delete view.
﻿DROP VIEW﻿
Statements Related to Function
Purpose
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
Create a function.
﻿CREATE FUNCTION﻿
﻿
﻿
﻿
﻿
View function creation statements
﻿SHOW FUNCTION﻿
Delete a function.
﻿DROP FUNCTION﻿
DML Statements
Purpose
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
Insert a row of data.
﻿INSERT STATEMENT﻿
﻿
﻿
Replace a row of data.
﻿INSERT OVERWRITE﻿
Update data by row (for replacing INSERT OVERWRITE).
﻿MERGE INTO﻿
Query Iceberg table metadata.
﻿TABLE METADATA﻿
Insert query results to the data table.
﻿INSERT INTO﻿
﻿
﻿
Delete data of Iceberg table.
﻿DELETE STATEMENT﻿
Update the specified row.
﻿UPDATE﻿
DQL Statement
Purpose
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
﻿
Query data.
﻿SELECT STATEMENT﻿
﻿
﻿
﻿
﻿
For related reserved words, see Reserved Words.
﻿

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support

tencent cloud

Recent Pages

Overview of SuperSQL Statement

DDL Statements

Database-Related Statements

Data Table-Related Statements

Statements Related to View

Statements Related to Function

DML Statements

DQL Statement

Was this page helpful?

Was this page helpful?

Purpose	Statement
Create a database.	CREATE DATABASE
Display all databases defined in this metadata.	SHOW DATABASES
View database attributes.	DESCRIBE DATABASE
Change database attributes.	ALTER DATABASE SET DBPROPERTIES
Change database storage location.	ALTER DATABASE SET LOCATION
Delete a database.	DROP DATABASE

Purpose	Statement
Create a data table.	CREATE TABLE
Update table snapshot.	REPLACE TABLE AS SELECT
Query data table creation statements.	SHOW CREATE TABLE
Query table attributes.	SHOW TBLPROPERTIES
Query all tables in database.	SHOW TABLES
View column information and metadata information on the data table.	DESCRIBE TABLE
Query column information on the data table.	SHOW COLUMNS IN TABLE
Add a column to the data table.	ALTER TABLE ADD COLUMNS
Add a column to the data table.	ALTER TABLE ADD COLUMN AFTER/FIRST













































Chang a field name.	ALTER TABLE ... RENAME COLUMN
Delete a field in the data table.	ALTER TABLE DROP COLUMN
Add a partition to the data table.	ALTER TABLE ADD PARTATION
List table partitions.	SHOW PARTITIONS
Delete a partition of the data table.	ALTER TABLE DROP PARTITION
Add a partition field to the Iceberg table.	ALTER TABLE ADD PARTITION FIELD
Delete a partition field of the Iceberg table.	ALTER TABLE DROP PARTITION FIELD
Change data table attributes.	ALTER TABLE SET TBLPROPERTIES
Change data table storage location.	ALTER TABLE SET LOCATION
Change the sorting method of data in the table.	ALTER TABLE ... WRITE ORDERED BY
Change data distribution policy of partitioned table.	ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION
Add identifier fields attribute.	ALTER TABLE ... SET IDENTIFIER FIELDS
Add identifier fields attribute.	ALTER TABLE ... SET IDENTIFIER FIELDS
Delete identifier fields attribute.	ALTER TABLE ... DROP IDENTIFIER FIELDS
Update partition information.	MSCK REPAIR TABLE
Perform statistics on data table.	ANALYZE TABLES
Delete metadata table.	DROP TABLE
Display logical or physical plan for executing SQL statements.	EXPLAIN
Call table-related stored procedure.	CALL STATEMENT

Purpose	Statement
Create a view based on results of SELECT statement.	CREATE VIEW AS
Query view in the database.	SHOW VIEWS
Check view attributes.	DESCRIBE VIEW
Display view creation statements.	SHOW CREATE VIEW
Check view columns.	SHOW COLUMNS IN VIEW
Change view name.	ALTER VIEW RENAME TO













































Change view attributes.	ALTER VIEW SET TBLPROPERTIES
Delete view.	DROP VIEW

Purpose









































Create a function.	CREATE FUNCTION


View function creation statements	SHOW FUNCTION
Delete a function.	DROP FUNCTION

Purpose





































Insert a row of data.	INSERT STATEMENT
Insert a row of data.	INSERT STATEMENT
Replace a row of data.	INSERT OVERWRITE
Update data by row (for replacing INSERT OVERWRITE).	MERGE INTO
Query Iceberg table metadata.	TABLE METADATA
Insert query results to the data table.	INSERT INTO
Insert query results to the data table.	INSERT INTO
Delete data of Iceberg table.	DELETE STATEMENT
Update the specified row.	UPDATE

tencent cloud

Sign Up

Log in

Recent Pages

Overview of SuperSQL Statement

DDL Statements

Database-Related Statements

Data Table-Related Statements

Statements Related to View

Statements Related to Function

DML Statements

DQL Statement

Was this page helpful?

Was this page helpful?