Ultimate access to all questions.
A data engineer attempts to delete a Spark SQL table named my_table
, intending to remove both its metadata and data. They use the command: DROP TABLE IF EXISTS my_table;
. After execution, my_table
disappears from the table list, but the data files remain. Why do the data files persist despite the metadata deletion?