TRUNCATE TABLE on an external table

If you upgraded to CDP Private Cloud Base 7.1.6 or earlier from a version of Hive that supported TRUNCATE TABLE on external tables, you need to change your applications that use the command in this way. Truncating an external table results in an error. CDP Private Cloud Base 7.1.7 fixes this problem, and you can truncate an external or a managed (ACID) table.

Before Upgrade to CDP

Some legacy versions of Hive supported TRUNCATE TABLE on external tables.

After Upgrade to CDP Private Cloud Base 7.1.6 or earlier

TRUNCATE TABLE is supported only on managed tables. Attempting to truncate an external table results in the following error:
Error: org.apache.spark.sql.AnalysisException: Operation not allowed: TRUNCATE TABLE on external tables

Action Required

Change applications. Do not attempt to run TRUNCATE TABLE on an external table.