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;

系统响应

可以确认任务状态成功，运行QUERY语句查看表中对应数据已被删除。