Modifying the HSMM process

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 Cloudera Manager Hive Upgrade Process.

You must upgrade Cloudera Manager to CM 7.x before modifying the HSMM process.

You must perform this procedure on your CM 7.x installation before starting the Cluster Upgrade Wizard.

Perform this procedure if you want to expedite the upgrade process; otherwise, skip this procedure and manually handle missing table or partition locations and check SERDE definitions.
  1. Open the following file for editing: /opt/cloudera/cm-agent/service/hive/hive.sh
  2. Modify the following Cloudera Manager Agent Script on each agent node (or at least those nodes that have either Hive on Tez or Hive Services) to run only the “db” definition process as shown in the following example:

    FROM

    exec $HIVE_HOME/bin/hive --config $CONF_DIR --service
    strictmanagedmigration --migrationOption external --fsOperationUser $2

    TO

    exec $HIVE_HOME/bin/hive --config $CONF_DIR --service
    strictmanagedmigration --migrationOption external --fsOperationUser $hdfs
    --tableRegex zzzzz 
  3. Restart the Cloudera Manager and agents after this change but before starting the upgrade process.