DELETE

命令功能

DELETE命令从Hudi表中删除记录。该命令根据指定的过滤条件删除符合条件的记录，支持基于条件表达式和子查询的删除方式。

命令格式

DELETE from tableIdentifier [ WHERE boolExpression]

参数描述

示例

• 示例1：

  delete from h0 where column1 = 'country';

• 示例2：

  delete from h0 where column1 IN ('country1', 'country2');

• 示例3：

  delete from h0 where column1 IN (select column11 from sourceTable2);

• 示例4：

  delete from h0 where column1 IN (select column11 from sourceTable2 where column1 = 'xxx');

• 示例5：

  delete from h0;

系统响应

可在driver日志和客户端中查看命令运行成功或失败。