hive 向表中插入查询数据 job运行完报错 如何解决
Loadingdatatotablesogou2.sogou_partitionpartition(year=null,month=null,day=null,hour=...
Loading data to table sogou2.sogou_partition partition (year=null, month=null, day=null, hour=null)
Failed with exception MetaException(message:javax.jdo.JDODataStoreException: Error(s) were found while auto-creating/validating the datastore for classes. The errors are printed in the log, and are attached to this exception.
NestedThrowablesStackTrace:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
以用alter database hive character set latin1;修改过还是出现错误
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask 展开
Failed with exception MetaException(message:javax.jdo.JDODataStoreException: Error(s) were found while auto-creating/validating the datastore for classes. The errors are printed in the log, and are attached to this exception.
NestedThrowablesStackTrace:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
以用alter database hive character set latin1;修改过还是出现错误
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask 展开
展开全部
`tomember` varchar(12) default NULL,
`sex` varchar(2) default NULL,
`count` int(4) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
/
`sex` varchar(2) default NULL,
`count` int(4) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
/
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
