05-11-2017 12:40 AM
I am trying to skip the trash while doing insert overwrite on an external table from hive.
Tried using :
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?
05-11-2017 08:00 PM - edited 05-11-2017 08:05 PM
the other way around is to use em in Table properties , i belive it holds true for managed table .
not sure for external table , please try it let me know if you can .
TBLPROPERTIES ("auto.purge"="true") or ("auto.purge"="false") in release 1.2.0