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 问题解决