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

DELETE from tableIdentifier [ WHERE boolExpression]

**Table 1** Parameters
Parameter	Description
tableIdentifier	Name of the Hudi table to delete records.
boolExpression	Filtering conditions for deleting records.

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 = 'USA');

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