HIVE插入数据数据少时可以数据大时失败

最新推荐文章于 2023-09-20 21:43:04 发布

weixin_42789202

最新推荐文章于 2023-09-20 21:43:04 发布

阅读量686

点赞数 1

分类专栏：大数据文章标签： hadoop

本文链接：https://blog.youkuaiyun.com/weixin_42789202/article/details/107109075

版权

tez为hive引擎,执行sql（7G表到orc动态分组表 30多个分区）：

insert overwrite table dmtest.business_licence_SOFT_INFOE_s partition(AREA_CODE) select enterprise_id,revoke_flag,REGISTER_TIME,update_time, AREA_CODE from dmtest.business_licence_SOFT_INFOE_H ;

动态分区插入

Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"enterprise_id":"34000004046964","area_code":"340000","register_time":"2019-10-06 00:00:00","revoke_flag":"1","update_time":"2020-07-03"}
   at org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.processRow(MapRecordSource.java:95)
   at org.apache.hadoop.hive.ql.exec.tez.MapRecordSource.pushRecord(MapRecordSource.java:70)
   at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.run(MapRecordProcessor.java:419)
   at or