We’re testing dropping external table with auto_purge=true , but it seems it still only dropped the metadata and left the referenced data dir there. Our setup for hive is AWS Glue + AWS S3. I’m wondering if the auto_purge is not supported for our setup or we missed anything?
I believe this property only works for the Hive metastore. But, Trino should delete the data when dropping a table in Glue. You can check for a WARN message in the coordinator logs with a message Failed to delete path. Trino will delete the data if it’s a managed table but not with an external table. Enable debug level log and see if you can find anything there