DELETE Hudi Data¶
Function¶
This command is used to delete records from a Hudi table.
Syntax¶
DELETE from tableIdentifier [ WHERE boolExpression]
Parameter Description¶
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 = 'USA');
Example 5:
delete from h0;
System Response¶
You can view the result in driver logs or on the client.