On this page

Function
Syntax
Parameter Description
Precautions
Examples
System Response

Show all

Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using CarbonData/ CarbonData Syntax Reference/ DML/ DELETE RECORDS from CARBON TABLE

DELETE RECORDS from CARBON TABLE

Updated on 2023-02-21 GMT+08:00

View PDF

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

Previous topic: UPDATE CARBON TABLE

Next topic: INSERT INTO CARBON TABLE

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback