https://community.cloudera.com/t5/Support-Questions/upgrade-hive-schema-failed/m-p/51299#M5927 Ok, had to get my MySQL DBA hat back out.<BR /><BR />InnoDB max key length is 767 bytes and MyISAM's is 1000. Latin1 is a character to byte equivalent while utf8 requires additional bytes per character. So the key that is trying to add to this table at a minimum is 1151 bytes.<BR /><BR />I just checked out my CDH 5.8.2 metastore and see the same index and same column sizes. So I don't have idea why it is an issue for you. Can you try upgrading to a lower CDH version first? Wed, 22 Feb 2017 06:16:53 GMT mbigelow 2017-02-22T06:16:53Z