tencent cloud

Feedback

DELETE STATEMENT

Last updated: 2024-08-07 17:26:46

    Description

    Supported engine: SparkSQL
    Applicable table: Native Iceberg tables
    Purpose: Delete specified row in the data table.

    Statement

    DELETE FROM table_name [ [ AS ] alias ]
    [ WHERE booleanExpression ]

    Parameter

    table_identifier: Table name in the three-part format. Example: catalog.database.table.

    Example

    DELETE FROM lineitem WHERE shipmode = 'AIR';
    
    DELETE FROM lineitem
    WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');
    
    DELETE FROM orders;
    
    
    
    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