在从Hive2.3.6升级到Hive3.1.3的过程中，遇到了coalesce报错、MR任务失败、关键字冲突、from_unixtime时区改变等问题。针对这些问题，解决方案包括关闭严格类型检查、禁用向量化执行、字段名加反引号避免关键字冲突、修改时区设置以及更新mapred-site.xml配置。上线前的数仓检查及时发现并解决了这些潜在问题。
1、coalesce报错
FAILED: SemanticException [Error 10014]: Line 197:4 Wrong arguments ''10'': Unsafe compares
BETWEEN different types are disabled for safety reasons. If you know what you are doing,
please SET hive.strict.checks.type.safety to false
AND make sure that hive.mapred.mode is NOT SET to 'strict' to proceed. Note that you may get errors
OR incorrect results if you make a mistake while
USING some of the unsafe features.
最低0.47元/天 解锁文章
7753
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
