Prevent SparkSQL Incompatibility
If you did not convert your managed, non-ACID tables to external tables before the upgrade, the upgrade process converts the hive-owned files to ACID v2 files. These files are not SparkSQL compatible. Convert these files to external files before the CDP upgrade.
Run the SHOW CREATE TABLE statement on the original table to get the full definition of the table.
SHOW CREATE TABLE <tablename>;
Rename the managed table to
Migrate data from *_old to <new> external table using the original name in the
historical or the default location
CREATE EXTERNAL TABLE new_t AS SELECT * FROM old_t;