DELETE STATEMENT

最近更新时间:2023-03-08 16:30:43

我的收藏

说明

支持内核:SparkSQL。
适用表范围:原生 Iceberg 表。
用途:删除数据表中的指定行。

语法

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

参数说明

table_identifier:指定表名,支持三段式,例如:catalog.database.table

示例

DELETE FROM lineitem WHERE shipmode = 'AIR';

DELETE FROM lineitem
WHERE orderkey IN (SELECT orderkey FROM orders WHERE priority = 'LOW');

DELETE FROM orders;