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 …