By default, the Hive Strict Managed Migration process (HSMM) runs across all tables
and databases. But, you want to prevent HSMM from migrating tables and databases. To change
the default, you must directly modify the Ambari-DC Hive Upgrade Process.
You upgraded to Ambari-DC, but have not yet performed the HDP upgrade of the
platform stack from Hive 1 to Hive 3. Perform this procedure if you want to expedite the upgrade process.
Open the following script on the Ambari Server host for editing:
/var/lib/ambari-server/resources/stacks/HDP/3.0/services/HIVE/package/scripts/post_upgrade.py
Make the changes as shown in the following example: