Migrating Hive 1-2 to Hive 3

Hive Configuration Changes Requiring Consent
Before the CDH to CDP upgrade process starts, the pre-upgrade wizard asks you to consent to a number of critical configuration changes that occur after the upgrade. To prepare for this step, you can review the default before and after upgrade values of the properties.
Remove transactional=false from Table Properties
In CDH 5.x it is possible to create tables with having the property transactional=false set. While this is a no-op setting, if any of your Hive tables explicitly set this, the upgrade process fails.

Parent topic: CDP Private Cloud Base Pre-upgrade transition steps