Yang, Tong 3f5759eed2 MRS comp-lts 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2023-01-19 17:08:45 +00:00

5.0 KiB

Raw Permalink Blame History

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

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

System Response

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

Parent topic: DML

5.0 KiB Raw Permalink Blame History