Created 05-28-2020 08:46 PM
HI @Heri,
Here I just wanna add some points. You can use PURGE option to delete data file as well along with partition metadata but it works only in Internal/ Managed tables
ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec PURGE;
But for External tables have a two-step process to alter table drop partition + removing file
ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec;
hdfs dfs -rm -r <partition file path>
I hope this gives some insights here. cc @aakulov