Release Notes

Product Introduction

Overview

Strengths

Use Cases

Purchase Guide

Billing Overview

Refund

Payment Overdue

Configuration Adjustment Fees

Getting Started

Complete Process for New User Activation

DLC Data Import Guide

Quick Start with Data Analytics in Data Lake Compute

Quick Start with Permission Management in Data Lake Compute

Quick Start with Partition Table

Enabling Data Optimization

Cross-Source Analysis of EMR Hive Data

Standard Engine Configuration Guide

Configuring Data Access Policy

Operation Guide

Console Operation Introduction

Development Guide

Runtime Environment

SparkJar Job Development Guide

PySpark Job Development Guide

Query Performance Optimization Guide

UDF Function Development Guide

System Restraints

Client Access

JDBC Access

TDLC Command Line Interface Tool Access

Third-party Software Linkage

Python Access

Practical Tutorial

Accessing DLC Data with Power BI

Table Creation Practice

Using Apache Airflow to Schedule DLC Engine to Submit Tasks

Direct Query of DLC Internal Storage with StarRocks

Spark cost optimization practice

DATA + AI

Using DLC to Analyze CLS Logs

Using Role SSO to Access DLC

Resource-Level Authentication Guide

Implementing Tencent Cloud TCHouse-D Read and Write Operations in DLC

DLC Native Table

SQL Statement

SuperSQL Statement

Overview of Standard Spark Statement

Overview of Standard Presto Statement

Reserved Words

API Documentation

History

Introduction

API Category

Making API Requests

Data Table APIs

Task APIs

Metadata APIs

Service Configuration APIs

Permission Management APIs

Database APIs

Data Source Connection APIs

Data Optimization APIs

Data Engine APIs

Resource Group for the Standard Engine APIs

Data Types

Error Codes

General Reference

Error Codes

Quotas and limits

Operation Guide on Connecting Third-Party Software to DLC

FAQs

FAQs on Permissions

FAQs on Engines

FAQs on Features

FAQs on Spark Jobs

DLC Policy

Data Privacy And Security Agreement

Service Level Agreement

Overview of SuperSQL Statement

PDF

Focus Mode

Font Size

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.
﻿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.
﻿

Help and Support

Was this page helpful?

You can also Contact sales or Submit a Ticket for help.

Help us improve! Rate your documentation experience in 5 mins.

Feedback

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

Data Lake Compute

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

Help and Support