一、Hive不能建表
有可能会出现以下文字提示:
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
其中有可能是因为Hive没有将MySQL的结构映射过去,先去shell窗口输入命令:./schematool -dbType mysql -initSchema
,然后如果出现 schemaTool completed ,就说明Hive可以建表了。
如果出现 schemaTool completed ,详情请见第二大点。