TRUNCATE TABLE on an external table

If you upgraded 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.

Before Upgrade to CDP

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

After Upgrade to CDP

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.