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.