Hive> CREATE TABLE dummy(value STRING);
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
参考网络上的文章:
h2内存数据库-hive的Specified key was too long; max key length is 767 bytes问题解决
解决方法:
mysql > alter database hive character set latin1;
再在Hive里创建表已经ok了