Overview of Standard Presto Statement

Recent Pages

Overview of Standard Presto Statement

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

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

Was this page helpful?

Was this page helpful?

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

Sign Up

Log in

Recent Pages

Overview of Standard Presto Statement

Was this page helpful?

Was this page helpful?