分享

求助 hive插入数据失败

hive> insert overwrite table fp3 select farm_id , group_id ,time,regexp_replace(power_forecast,'NA','') from fp1;
Query ID = root_20160717160918_0fa00313-ec8e-4079-a642-b420fca15cba
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1463811115991_0016, Tracking URL = http://node-master2-845ae.com:80 ... 1463811115991_0016/
Kill Command = /data0/app/cloud/client/hadoop/bin/hadoop job  -kill job_1463811115991_0016
Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
2016-07-17 16:09:23,368 Stage-1 map = 0%,  reduce = 0%
Ended Job = job_1463811115991_0016 with errors
Error during job, obtaining debugging information...
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
MapReduce Jobs Launched:
Stage-Stage-1:  HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec

已有(4)人评论

跳转到指定楼层
请叫我野区养猪 发表于 2016-7-18 15:29:30
有人知道这是怎么回事吗
现在能查 能load 但是insert 就是会失败 怎么回事了
回复

使用道具 举报

nextuser 发表于 2016-7-18 19:56:47
请叫我野区养猪 发表于 2016-7-18 15:29
有人知道这是怎么回事吗
现在能查 能load 但是insert 就是会失败 怎么回事了

表结构是否一样,如果不一样会报错
回复

使用道具 举报

arsenduan 发表于 2016-7-18 19:58:37
可能是格式的问题,楼主先尝试简单的格式
regexp_replace(power_forecast,'NA','') 改为正常格式power_forecast
回复

使用道具 举报

chyeers 发表于 2016-8-1 16:47:02
先到jobhistory看看失败完整日志吧
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

推荐上一条 /2 下一条