hive报错MetaException(message:An exception was thrown while adding/validating class

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:An exception was thrown while adding/validating class(es) : Column length too big for column 'PARAM_VALUE' (max = 21845); use BLOB or TEXT instead
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Column length too big for column 'PARAM_VALUE' (max = 21845); use BLOB or TEXT instead
at sun.reflect.GeneratedConstructorAccessor30.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408

查了一下是hive使用MySQL存储元数据编码问题

解决办法
进入MySQL

mysql> alter database hive character set latin1;
Query OK, 1 row affected (0.01 sec）

重新运行hive 问题解决

最后

以上就是深情毛巾为你收集整理的hive报错MetaException(message:An exception was thrown while adding/validating class的全部内容，希望文章能够帮你解决hive报错MetaException(message:An exception was thrown while adding/validating class所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。