dropping a managed table does not remove the underlying files

my_community2
New Contributor III

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:

image.pngthen 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)