Ultimate access to all questions.
In the context of managing a Spark SQL table named my_table
, a data engineer wants to completely remove the table along with all its associated metadata and data. They use the command DROP TABLE IF EXISTS my_table
. Although the table is no longer listed when they execute SHOW TABLES
, they notice that the data files still persist. What is the reason that the data files remain in place while the metadata files were deleted?