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

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.