tencent cloud

Data Lake Compute

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
Privacy Policy
Data Privacy And Security Agreement
Service Level Agreement
Contact Us
DocumentationData Lake ComputeSQL StatementOverview of Standard Spark Statement

Overview of Standard Spark Statement

PDF
Focus Mode
Font Size
Last updated: 2026-01-16 17:18:09
The kernel of the Standard Spark Engine is self-developed based on Spark Version 3.2 and is compatible with native Spark syntax and behavior. For detailed syntax, please refer to the Spark documentation.

DDL Syntax

Database-related Syntax

Use
Syntax
New database
CREATE DATABASE
Display all databases in the Metadata Definition
SHOW DATABASES
View database attributes
DESCRIBE DATABASE
Database attribute changes
ALTER DATABASE SET DBPROPERTIES
Dropping a Database
DROP DATABASE

Data table related syntax

Use
Syntax
New Data Table
CREATE TABLE
Query Table Creation Information
SHOW CREATE TABLE
Query Table Attributes
SHOW TBLPROPERTIES
Query All Tables in Database
SHOW TABLES
View Data Table Column Information and Metadata
DESCRIBE TABLE
Add Column to Data Table
ALTER TABLE ADD COLUMNS
Add New Column to Data Table
ALTER TABLE ADD COLUMN AFTER/FIRST
Rename Field
ALTER TABLE ... RENAME COLUMN
Delete a Field from Data Table
ALTER TABLE DROP COLUMN
Add Partition Information to Data Table
ALTER TABLE ADD PARTITION
List Table Partitions
SHOW PARTITIONS
Delete Partition Information from Data Table
ALTER TABLE DROP PARTITION
Add Partition Field to Iceberg Table
ALTER TABLE ADD PARTITION FIELD
Delete Partition Field from Iceberg Table
ALTER TABLE DROP PARTITION FIELD
Data Table Attribute Changes
ALTER TABLE SET TBLPROPERTIES
Data Table Storage Location Changes
ALTER TABLE SET LOCATION
Modify Table Data Sorting Method
ALTER TABLE ... WRITE ORDERED BY
Modify Partition Table Allocation Policy
ALTER TABLE ... WRITE DISTRIBUTED BY PARTITION
Update Partition Information (Iceberg table version V2 is not supported.)
MSCK REPAIR TABLE
Delete Metadata Table
DROP TABLE
Display the logical or physical plan of executing SQL
EXPLAIN
Call table stored procedure
CALL STATEMENT

View-related syntax

Use
Syntax
Create a view from the select result
CREATE VIEW AS
Query views in the database
SHOW VIEWS
View column information of the view
DESCRIBE VIEW
Show view creation statement
SHOW CREATE VIEW
View column information of the view
SHOW COLUMNS IN VIEW
Modify view name
ALTER VIEW RENAME TO
Modify view attribute
ALTER VIEW SET TBLPROPERTIES
Delete View
DROP VIEW

Function related syntax

Use
Creating function
CREATE FUNCTION
View create function syntax
SHOW FUNCTION
Deleting function
DROP FUNCTION

DML Syntax

Use
Insert a row of data
INSERT STATEMENT
Replace a row of data
INSERT OVERWRITE
Row-level data update operation, which can be used to replace the INSERT OVERWRITE Operation
MERGE INTO
Iceberg Table Metadata Query
TABLE METADATA
Insert query results into a data table
INSERT INTO
Delete data from Iceberg Table
DELETE STATEMENT
Update specified row
UPDATE

DQL Syntax

Use
Data Query
SELECT STATEMENT

Previous Topic: Comparison of Hive FunctionsNext Topic: Overview of Standard Presto Statement

Help and Support

Was this page helpful?

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

Feedback