tencent cloud

Data Lake Compute

DokumentasiData Lake Compute

Overview of Standard Presto Statement

Mode fokus
Ukuran font
Terakhir diperbarui: 2026-04-15 21:29:52
The standard Presto engine kernel is based on Presto 0.242 self-research, compatible with native Presto syntax and behavior, suitable for interactive query analysis. For detailed syntax, please refer to the Presto syntax documentation.
Note:
The Presto engine has been deprecated and is only available for existing users.
Use
Syntax
Supported
Remarks
Modifying Function Definition
ALTER FUNCTION
No

Renaming Schema
ALTER SCHEMA
Yes

Modifying Data Table
ALTER TABLE
Yes
Only Iceberg Tables are supported.
Execution requires specifying the target table's Iceberg catalog in three-part format or by executing use iceberg.dbname first
Statistics on Data Table
ANALYZE
Yes
Only Hive Tables are supported
It commits the current transaction
COMMIT
No

Creating function
CREATE FUNCTION
No

Creates role
CREATE ROLE
No

Create SCHEMA
CREATE SCHEMA
No

Creating Table
CREATE TABLE
No

Use SELECT to create a table
CREATE TABLE AS
No

Create View
CREATE VIEW
No

Delete PREPARE
DEALLOCATE PREPARE
No

Deleting Data
DELETE
No

Display column information
DESCRIBE
Yes

Display PREPARE input information
DESCRIBE INPUT
No

Display PREPARE output information
DESCRIBE OUTPUT
No

Deleting function
DROP FUNCTION
No

Deletes role
DROP ROLE
No

Delete SCHEMA
DROP SCHEMA
No

Dropping a Table
DROP TABLE
No

Delete View
DROP VIEW
No

Run PREPARE
EXECUTE
Yes

Display the Logical or Physical Plan of the Executing SQL
EXPLAIN
Yes

Run SQL and Display Execution Plan
EXPLAIN ANALYZE
Yes

Authorization
GRANT
No

Grant Role Authorization to Specify Objects
GRANT ROLE
No

Inserting Data
INSERT
Yes
If it is an Iceberg table, execution requires specifying the target table's Iceberg catalog in three-part format or by executing use iceberg.dbname first
Creating PREPARE
PREPARE
Yes

Specify SESSION to reset to default
RESET SESSION
Yes

Revoke Authorization
REVOKE
No

Revoke Granted Role
REVOKE ROLES
No

Rolling back transaction
ROLLBACK
No

Querying Data
SELECT
Yes

Set the role
SET ROLE
No

Set the specified SESSION value
SET SESSION
Yes

Display CATALOG list
SHOW CATALOGS
Yes

Display table column information
SHOW COLUMNS
Yes

Display function information
SHOW CREATE FUNCTION
No

Display Table Creation Information
SHOW CREATE TABLE
Yes

Display Create View Information
SHOW CREATE VIEW
No

Display Function List
SHOW FUNCTIONS
Yes

Display Permissions of Designated User
SHOW GRANTS
No

Display Authorized Role List
SHOW ROLE GRANTS
No
Display Role List
SHOW ROLES
No

Display SCHEMA List
SHOW SCHEMAS
Yes

Display SESSION List
SHOW SESSION
Yes

Display Table Statistical Information
SHOW STATS
Yes
Display Table List
SHOW TABLES
Yes

Start Transaction
START TRANSACTION
No

Delete All Table Content
TRUNCATE
No

Update Table Content
UPDATE
No

Set Default SCHEMA or Database
USE
Yes

Definition Inline Table
VALUES
Yes


Topik selanjutnya: Kebijakan Privasi

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan