tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Data Lake Compute
    Documentation
    Download PDF

    Overview of Standard Presto Statement

    Last updated: 2024-08-07 17:35:31
    Download PDF
    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.

    Contact Us
    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    Submit a Ticket
    7x24 Phone Support
    Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
    Privacy PolicyLegalCookie Policy