I am trying to skip the trash while doing insert overwrite on an external table from hive.   Tried using :   SET hive.warehouse.data.skiptrash=true;   ALTER TABLE TABLE_NAME DROP IF EXISTS partition(partition_value) PURGE;   Is there any alternative command from HIVE other than a hard delete on HDFS? ... View more