Explanation:
Dropping an external table removes its catalog metadata but leaves files at the externally specified location. The files are not owned or lifecycle-managed by the metastore. Dropping a managed table generally removes both its metadata and underlying data, subject to platform retention behavior.
A Spark SQL table is dropped with DROP TABLE IF EXISTS my_table; the metadata disappears, but the data files remain. Why?
A
The table’s data was larger than 10 GB.
B
The table’s data was smaller than 10 GB.
C
The table was external.
D
The table did not have a location.
E
The table was managed.
No comments yet.