DELETE
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. |
Example
- 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 confirm the job status as successful and run a QUERY statement to verify that the corresponding data in the table has been deleted.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot