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¶
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.