Here is work around, which i have implemented. For an external table, If you are trying to drop a partition and as-well would like to delete the data. This can be achieved as below. 1. Alter external table as internal table -- by changing the TBL properties as external =false 2. Drop the partitions -- when you drop the partitions, data pertained to the partitions will also be dropped as now this table is managed table 3. Alter back the table as external=True. By doing this, there more controlled on what we are deleting and drop the partitions rather than using hadoop rm command
... View more
