I need to DROP a hive table and clear data in HDFS. But I can't convert it from External to Managed (I have to create external table for my business).
On Spark 2.0.2, I can use script ALTER TABLE <tbl_name> SET TBLPROPERTIES ('EXTERNAL' = 'FALSE'); then I execute script DROP TABLE <tbl_name>; metadata and data was deleted together.
But on spark 2.4.4, it's not work. I need a solution for that (drop a external table and drop data in hdfs or convert a external table to managed table and drop it).