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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.