hivetruncateexternal-tableshive-partitionshiveddl

How to truncate a partitioned external table in hive?

I'm planning to truncate the hive external table which has one partition. So, I have used the following command to truncate the table :

 hive> truncate table abc;

But, it is throwing me an error stating : Cannot truncate non-managed table abc.

Can anyone please suggest me out regarding the same ...

Solution

  • Make your table MANAGED first:

    ALTER TABLE abc SET TBLPROPERTIES('EXTERNAL'='FALSE');

    Then truncate:

    truncate table abc;

    And finally you can make it external again:

    ALTER TABLE abc SET TBLPROPERTIES('EXTERNAL'='TRUE');