Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hudi/ Hudi SQL Syntax Reference/ DML/ DELETE
Updated on 2023-02-21 GMT+08:00
View PDF

DELETE

Function

This command is used to delete records from a Hudi table.

Syntax

DELETE from tableIdentifier [ WHERE boolExpression]

Parameter Description

Table 1 Parameters

Parameter

Description

tableIdentifier

Name of the Hudi table to delete records.

boolExpression

Filtering conditions for deleting records.

Examples

  • Example 1: 
    delete from h0 where column1 = 'country';
  • Example 2: 
    delete from h0 where column1 IN ('country1', 'country2');
  • Example 3: 
    delete from h0 where column1 IN (select column11 from sourceTable2);
  • Example 4: 
    delete from h0 where column1 IN (select column11 from sourceTable2 where column1 = 'xxx');
  • Example 5: 
    delete from h0;

System Response

You can view the result in driver logs or on the client.

Parent topic: DML