tencent cloud

Data Lake Compute

DokumentasiData Lake Compute

DELETE STATEMENT

Unduh
Mode fokus
Ukuran font
Terakhir diperbarui: 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;



Topik selanjutnya: Kebijakan Privasi

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan