Post-Upgrade Steps for Hive
Complete the following steps after you upgrade Hive with or without the MapR Installer.
About this task
Procedure
-
Migrate Hive Configuration.
Migrate any custom configuration settings into the Hive 2.3 version in the
/opt/mapr/hive/hive-2.3/conf/
directory. -
Update the Hive Metastore.
For upgrades from the old version of Hive to the new version, run the
schematool
command with the-upgradeSchema
option.NOTE Review and, if necessary, perform the steps described in Troubleshooting Hive Upgrade Issues before running this command./opt/mapr/hive/hive-<version>/bin/schematool -dbType <metastore_database> -upgradeSchema
For example, for upgrades from Hive 2.1 to 2.3 on MySQL, run the following command:/opt/mapr/hive/hive-2.3/bin/schematool -dbType mysql -upgradeSchema
-
Run
configure.sh -R
.
This step enables Warden to recognize the newly installed services./opt/mapr/server/configure.sh -R
-
Verify that the metastore database update completed successfully. You can use the following diagnostic tests:
- Run the
show tables
command in Hive and make sure it returns a complete list of all your Hive tables. - Perform simple SELECT operations on Hive tables that existed before the upgrade.
- Perform filtered SELECT operations on Hive tables that existed before the upgrade.
- Run the