tencent cloud

Data Lake Compute

DELETE STATEMENT

Download
Focus Mode
Font Size
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;




Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback