Hive Metastore Upgrade Failed with Error: Specified key was too long; max key length is 1000 bytes

Sympton: After upgrading Cloudera Manager (CM) from CDH5.3 to CDH5.4, the requirement was to also upgrade the Hive Metastore Database Schema: However, it failed with the following message: It is not immediately apparent what needs to be done. Initially you might think that some of the indexes contained too many …

Hive METASTORE exited unexpectedly, and no apparent error in the error log

This article explains how to trouble shoot the issue when Hive METASTORE dies with no apparent error message in the log. Cloudera Manager (short for CM) has a mechanism to kill the processes that have reached its memory allocations. So when this scenario happens, it usually means that Hive METASTORE …