tencent cloud

DELETE STATEMENT
Download PDF
Last updated: 2024-08-07 17:26:46
DELETE STATEMENT
Last updated: 2024-08-07 17:26:46
Download PDF

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;



Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback