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
Error: org.apache.spark.sql.AnalysisException: Operation not allowed: TRUNCATE TABLE on external tables
Change applications. Do not attempt to run TRUNCATE TABLE on an external table.