The Hive Strict Managed Migration process (HSMM) runs across all databases to ensure
the logic is applied to each database definition. But, you want HSMM to skip processing
tables in these databases. To stop this action, you must directly modify the Ambari-DC Hive
Upgrade Process.
You upgraded to Ambari-DC but have not yet performed the HDP upgrade
that will be used to upgrade the platform stack from Hive 1 to Hive 3.
Perform this procedure if you want to expedite the upgrade process as described in the last topic; otherwise,
skip this procedure and manually handle missing table or partition locations and check SERDE definitions.
-
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:
FROM
cmd = format("{hive_script} --config /etc/hive/conf --service strictmanagedmigration --hiveconf hive.strict.managed.tables=true -m automatic
--modifyManagedTables --oldWarehouseRoot /apps/hive/warehouse")
TO
cmd = format("{hive_script} --config /etc/hive/conf --service strictmanagedmigration --hiveconf hive.strict.managed.tables=true -m automatic
--modifyManagedTables --oldWarehouseRoot /apps/hive/warehouse --tableRegex zzzzz")
-
Restart the Ambari Server and agents after this change but before starting the upgrade
process.