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
04-11-2018 02:58 AM
Am I right in reading the 5.13.3 and 5.14.2 tarball components? They both use Hive 1.1.0 and not Hive 1.2.0
I have a very similar problem - I want to switch off hive using the trash for certain tables