Updated on 2022-11-18 GMT+08:00

CLEAN FILES

Function

After the DELETE SEGMENT command is executed, the deleted segments are marked as the delete state. After the segments are merged, the status of the original segments changes to compacted. The data files of these segments are not physically deleted. If you want to forcibly delete these files, run the CLEAN FILES command.

However, running this command may result in a query command execution failure.

Syntax

CLEAN FILES FOR TABLE [db_name.]table_name ;

Parameter Description

Table 1 CLEAN FILES FOR TABLE parameters

Parameter

Description

db_name

Database name. It consists of letters, digits, and underscores (_).

table_name

Name of the database table. It consists of letters, digits, and underscores (_).

Precautions

None

Examples

CLEAN FILES FOR TABLE CarbonDatabase.CarbonTable;

In this example, all the segments marked as deleted and compacted are physically deleted.

System Response

Success or failure will be recorded in the driver logs.