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

6.7 KiB

Raw Permalink Blame History

DELETE RECORDS from CARBON TABLE

Function

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

Syntax

DELETE FROM CARBON_TABLE [WHERE expression];

Parameter Description

**Table 1** DELETE RECORDS parameters
Parameter	Description
CARBON TABLE	Name of the CarbonData table in which the DELETE operation is performed

Precautions

If a segment is deleted, all secondary indexes associated with the segment are deleted as well.
If the carbon.input.segments property has been set for the queried table, the DELETE operation fails. To solve this problem, run the following statement before the query:
Syntax:

SET carbon.input.segments. <database_name>.<table_name>=*;

Examples

Example 1:
delete from columncarbonTable1 d where d.column1 = 'country';
Example 2:
delete from dest where column1 IN ('country1', 'country2');
Example 3:
delete from columncarbonTable1 where column1 IN (select column11 from sourceTable2);
Example 4:
delete from columncarbonTable1 where column1 IN (select column11 from sourceTable2 where column1 = 'USA');
Example 5:
delete from columncarbonTable1 where column2 >= 4;

System Response

Success or failure will be recorded in the driver log and on the client.

Parent topic: DML

6.7 KiB Raw Permalink Blame History