Hive Metastore corrupt
If the Hive Metastore is corrupt, you can perform specific steps to restore it.
-
On the node where the database for Hive Metastore resides, create databases you
want to restore. For example:
$ mysql -u hiveuser -p -e "create database <hive_db_schema_name>;" -
Restore each Metastore database from the dump you created. For example:
$ mysql -u hiveuser -p <hive_db_schema_name> < </path/to/dump_file> -
Reconfigure Hive Metastore if necessary. Reconfiguration might be necessary if
the upgrade fails. Contacting Cloudera Support for help with reconfiguration is
recommended. Alternatively, in intermediate bits, set
key=valuecommands on the command line to configure Hive Metastore.
