Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2022 05:47 PM
the documentation states that "drop table":
Deletes the table and removes the directory associated with the table from the file system if the table is not
EXTERNAL table. An exception is thrown if the table does not exist.
In case of an external table, only the associated metadata information is removed from the metastore schema.
This does not work!!
I have a managed table, see below, managed and stored on a mounted Azure storage account:
then I execute spark.sql("drop table silver.company")
the result:
- metadata is deleted from the catalog
- folder is NOT deleted from disk (it should have been deleted as per docs)
Labels:
- Labels:
-
Azure
-
External Table
-
Table