Why Do Files of a Carbon Table Exist in the Recycle Bin Even If the drop table Command Is Not Executed When Mis-deletion Prevention Is Enabled?

Question

Why do files of a Carbon table exist in the recycle bin even if the drop table command is not executed when mis-deletion prevention is enabled?

Answer

After the mis-deletion prevention is enabled for a Carbon table, calling a file deletion command will move the deleted files to the recycle bin.

The intermediate file .carbonindex is deleted duration the execution of the insert or load command. Therefore, the table files may exist in the recycle bin even through the drop table command is not executed.

If you run the drop table command, a table directory with a timestamp is generated. The files in the directory are complete.