
Ultimate access to all questions.
A data analyst is attempting to drop a table named my_table to delete both its metadata and data. They execute the following command:
DROP TABLE IF EXISTS my_table;
DROP TABLE IF EXISTS my_table;
After this command, the table no longer appears in the output of SHOW TABLES. However, the underlying data files still exist, while the metadata files have been deleted.
Why do the data files persist after the metadata files have been removed?