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 Standard Presto Statement

PDF

Focus Mode

Font Size

Last updated: 2024-08-07 17:35:31

The standard Presto engine kernel is based on Presto 0.242 and is self-developed. It is compatible with native Presto statement and behavior, suitable for interactive query analysis. For detailed statement, see the Presto statement documentation.
Purpose
Statement
Supported
Notes
Modify function definition.
ALTER FUNCTION
No
﻿
Rename Schema.
ALTER SCHEMA
Yes
﻿
Modify data table.
ALTER TABLE
Yes
Only supports Iceberg tables.
When executing, you must specify the target table's Iceberg catalog using a three-part name, or execute USE iceberg.dbname first.
Collect statistics on data table.
ANALYZE
Yes
Only supports Hive tables.
Commit current transaction.
COMMIT
No
﻿
Create function.
CREATE FUNCTION
No
﻿
Create role.
CREATE ROLE
No
﻿
Create SCHEMA.
CREATE SCHEMA
No
﻿
Create data table.
CREATE TABLE
No
﻿
Create table using SELECT.
CREATE TABLE AS
No
﻿
Create view.
CREATE VIEW
No
﻿
Delete PREPARE.
DEALLOCATE PREPARE
No
﻿
Delete data.
DELETE
No
﻿
Show column information.
DESCRIBE
Yes
﻿
Show PREPARE input information.
DESCRIBE INPUT
No
﻿
Show PREPARE output information.
DESCRIBE OUTPUT
No
﻿
Delete function.
DROP FUNCTION
No
﻿
Drop role.
DROP ROLE
No
﻿
Delete SCHEMA.
DROP SCHEMA
No
﻿
Delete data table.
DROP TABLE
No
﻿
Delete view.
DROP VIEW
No
﻿
Execute PREPARE.
EXECUTE
Yes
﻿
Show logical or physical execution plan of SQL.
EXPLAIN
Yes
﻿
Execute SQL and display execution plan.
EXPLAIN ANALYZE
Yes
﻿
Grant privileges.
GRANT
No
﻿
Grant role to specified object.
GRANT ROLE
No
﻿
Insert data.
INSERT
Yes
If the table is an Iceberg table, you must specify the target table's Iceberg catalog using a three-part name, or execute USE iceberg.dbname first.
Create PREPARE.
PREPARE
Yes
﻿
Reset SESSION to default value.
RESET SESSION
Yes
﻿
Revoke authorization.
REVOKE
No
﻿
Revoke granted role.
REVOKE ROLES
No
﻿
Rollback transaction.
ROLLBACK
No
﻿
Query data.
SELECT
Yes
﻿
Set role.
SET ROLE
No
﻿
Set value for specified SESSION.
SET SESSION
Yes
﻿
Show CATALOG list.
SHOW CATALOGS
Yes
﻿
Show column information of a table.
SHOW COLUMNS
Yes
﻿
Show function information.
SHOW CREATE FUNCTION
No
﻿
Show table creation information.
SHOW CREATE TABLE
Yes
﻿
Show view creation information.
SHOW CREATE VIEW
No
﻿
Show function list.
SHOW FUNCTIONS
Yes
﻿
Show permissions of specified user.
SHOW GRANTS
No
﻿
Show the list of granted roles.
SHOW ROLE GRANTS
No
﻿
Show role list.
SHOW ROLES
No
﻿
Show SCHEMA list.
SHOW SCHEMAS
Yes
﻿
Show SESSION list.
SHOW SESSION
Yes
﻿
Show table statistics.
SHOW STATS
Yes
﻿
Show table list.
SHOW TABLES
Yes
﻿
Start transaction.
START TRANSACTION
No
﻿
Delete all contents of a table.
TRUNCATE
No
﻿
Update table contents.
UPDATE
No
﻿
Set default SCHEMA or database.
USE
Yes
﻿
Define inline table.
VALUES
Yes
﻿
﻿

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	Supported	Notes
Modify function definition.	ALTER FUNCTION	No
Rename Schema.	ALTER SCHEMA	Yes
Modify data table.	ALTER TABLE	Yes	Only supports Iceberg tables. When executing, you must specify the target table's Iceberg catalog using a three-part name, or execute USE iceberg.dbname first.
Collect statistics on data table.	ANALYZE	Yes	Only supports Hive tables.
Commit current transaction.	COMMIT	No
Create function.	CREATE FUNCTION	No
Create role.	CREATE ROLE	No
Create SCHEMA.	CREATE SCHEMA	No
Create data table.	CREATE TABLE	No
Create table using SELECT.	CREATE TABLE AS	No
Create view.	CREATE VIEW	No
Delete PREPARE.	DEALLOCATE PREPARE	No
Delete data.	DELETE	No
Show column information.	DESCRIBE	Yes
Show PREPARE input information.	DESCRIBE INPUT	No
Show PREPARE output information.	DESCRIBE OUTPUT	No
Delete function.	DROP FUNCTION	No
Drop role.	DROP ROLE	No
Delete SCHEMA.	DROP SCHEMA	No
Delete data table.	DROP TABLE	No
Delete view.	DROP VIEW	No
Execute PREPARE.	EXECUTE	Yes
Show logical or physical execution plan of SQL.	EXPLAIN	Yes
Execute SQL and display execution plan.	EXPLAIN ANALYZE	Yes
Grant privileges.	GRANT	No
Grant role to specified object.	GRANT ROLE	No
Insert data.	INSERT	Yes	If the table is an Iceberg table, you must specify the target table's Iceberg catalog using a three-part name, or execute USE iceberg.dbname first.
Create PREPARE.	PREPARE	Yes
Reset SESSION to default value.	RESET SESSION	Yes
Revoke authorization.	REVOKE	No
Revoke granted role.	REVOKE ROLES	No
Rollback transaction.	ROLLBACK	No
Query data.	SELECT	Yes
Set role.	SET ROLE	No
Set value for specified SESSION.	SET SESSION	Yes
Show CATALOG list.	SHOW CATALOGS	Yes
Show column information of a table.	SHOW COLUMNS	Yes
Show function information.	SHOW CREATE FUNCTION	No
Show table creation information.	SHOW CREATE TABLE	Yes
Show view creation information.	SHOW CREATE VIEW	No
Show function list.	SHOW FUNCTIONS	Yes
Show permissions of specified user.	SHOW GRANTS	No
Show the list of granted roles.	SHOW ROLE GRANTS	No
Show role list.	SHOW ROLES	No
Show SCHEMA list.	SHOW SCHEMAS	Yes
Show SESSION list.	SHOW SESSION	Yes
Show table statistics.	SHOW STATS	Yes
Show table list.	SHOW TABLES	Yes
Start transaction.	START TRANSACTION	No
Delete all contents of a table.	TRUNCATE	No
Update table contents.	UPDATE	No
Set default SCHEMA or database.	USE	Yes
Define inline table.	VALUES	Yes

tencent cloud

Data Lake Compute

Overview of Standard Presto Statement

Help and Support