Yang, Tong 48706b7552 MRS COMP-LTS 320-lts.1 version

Reviewed-by: Kacur, Michal <michal.kacur@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2024-04-12 12:51:10 +00:00

5.0 KiB

Raw Permalink Blame History

DELETE Hudi Data

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

Example 5:
```
delete from h0;
```

System Response

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

Parent topic: Hudi DML

5.0 KiB Raw Permalink Blame History