hive 创建表报错
来源:3-5 【实操手册】Hive安装部署
慕小川
2024-08-16
老师,我通过 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) : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
我经过百度之后说是编码的问题 
hive、hadoop、mysql、jdk 用的都是课程提供的安装包 !这是怎么一回事呢 ?
参考了这个文章https://blog.csdn.net/gaoganghua/article/details/80621670
1回答
-
叁金
2024-08-16
MySQL数据执行以下这个命令试试:修改以下msyql字符集。hive之前好像默认需要latin1.
alter database hive character set latin1; 这里database替换成你自己的库。
修改完成之后需要重启一下hive的metastore服务。
00
相似问题