I have an external table which is created with partitions and i would like to delete/drop few partition along with data as i no longer require it.
Appreciate any suggestions.
Did you try to drop the partition using Hive query ? It should look like this :
ALTER TABLE <table_name> DROP PARTITION (<partition_col_name>='<value>');
If it does not delete the data you will need to delete the directory of the partition (in HDFS) after deleting it using the Hive query.
You can use PURGE option to delete data file as well along with partition mentadata but it works only in INTERNAL/MANAGED tables
ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec PURGE;
External Tables have a two step process to alterr table drop partition + removing file
ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec;
hadoop fs -rm -r <partition file path>