本文共 1715 字,大约阅读时间需要 5 分钟。
16/10/07 06:43:09 [2af60edc-63e5-4fed-adc1-c8e15dca3f34 2af60edc-63e5-4fed-adc1-c8e15dca3f34 main]: ERROR metastore.RetryingHMSHandler: HMSHandler Fatal error: javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : Specified key was too long; max key length is 767 bytescom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes at sun.reflect.GeneratedConstructorAccessor44.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
创建表的时候,报告了这个错误。经过网上查找,确定原因是因为mysql的 库的字符集问题。 解决:
用 root 登录mysql,然后修改hive数据库的字符集
mysql> show variables like '%char%';
mysql>alter database hive(库名) character set latin1;mysql>flush privileges;
修改表结构的时候i,报告错误
hive> > ALTER TABLE cwqsolo CHANGE id id String;FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. For direct MetaStore DB connections, we don't support retries at the client level.hive>
解决:
这个是因为hive用到的mysql 连接包版本不匹配的原因。 我安装的mysql 是 5.6.33,从网络上下载了一个mysql-connector-java-5.1.36.jar,替换,重启hive,问题解决。
[root@archive lib]# pwd/opt/hadoop/hive/lib[root@archive lib]# ls -l mysql-connector-java*-rw-r--r-- 1 root root 972007 Oct 7 07:06 mysql-connector-java-5.1.36.jar-rw-r--r-- 1 root root 703265 Sep 19 17:52 mysql-connector-java-5.1.6-bin.jar[root@archive lib]# [root@archive lib]# mv mysql-connector-java-5.1.6-bin.jar mysql-connector-java-5.1.6-bin.jar.bak
再次执行,不报错了。
hive -hiveconf hive.root.logger=DEBUG,console