关闭

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

356人阅读 评论(0) 收藏 举报
分类:
  • 运行代码
LOAD DATA LOCAL INPATH '/data/L.D.Xiao/allmac.txt' OVERWRITE INTO TABLE tag_model.abtesttable PARTITION (p_log_date='2017-01-01');
  • 报错
Failed with exception Wrong file format. Please check the file's format.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
  • 原因
hive> show create table abtesttable;
CREATE  TABLE `abtesttable`(
  `mac` string, 
  `type` string)
COMMENT 'ABTest mac list of the recommend system'
PARTITIONED BY ( 
  `p_log_date` string)
ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY '\t' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.RCFileInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
LOCATION
 'hdfs://hadoop03.chcloud.com:8020/warehouse/tag_model.db/abtesttable'
TBLPROPERTIES (
  'transient_lastDdlTime'='1482994280')
  • 解决办法
CREATE  TABLE `abtesttable_test`(
  `mac` string, 
  `type` string)
COMMENT 'ABTest mac list of CHiQ3 recommend system'
PARTITIONED BY ( 
  `p_log_date` string)
ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY '\t' 
STORED AS textfile;

 LOAD DATA LOCAL INPATH '/data/xinting.xiao/allmac.txt' OVERWRITE INTO TABLE tag_model.abtesttable_test PARTITION (p_log_date='2017-01-01');
  • 注意
insert overwrite table tag_model.abtesttable_test partition (p_log_date) select * from tag_model.abtesttable;
(若用:
insert into table tag_model.abtesttable_test partition (p_log_date) select * from tag_model.abtesttable;
则依旧会报错:
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
)
0
0
查看评论
发表评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场

load数据到hive分区表报错: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTas

在启动hive创建表的时候,兴许你们回碰到这个错误:http://blog.csdn.net/qq_35732963/article/details/54139581;百度一下,说是字符编码的问题,那...
  • qq_35732963
  • qq_35732963
  • 2017-01-09 20:07
  • 3322

hive:MoveTask

运行SQL时出了个错: SQL: INSERT OVERWRITE DIRECTORY 'result/testConsole' select count(1) from nutable; 错误信息:...
  • Xiaos_hui
  • Xiaos_hui
  • 2013-08-22 21:08
  • 7171

hive1.2.1 MoveTask报错

环境:hadoop2.6+hive1.2.1 这个MoveTask错误可能是由于权限引起的(如果启用了hdfs acl)。也可能是其他原因: 任务报错: Moving data to: hdfs...
  • zhoudetiankong
  • zhoudetiankong
  • 2015-10-14 11:34
  • 2501

Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask

hive 遇到的问题,总结一下: Query ID = grid_20151208110606_377592ad-5984-4f7b-9cfc-9cb2d6be4b6a Total jobs = 1 ...
  • u010011737
  • u010011737
  • 2015-12-08 15:29
  • 4432

Hive学习笔记 --- return code 1 from org.apache.hadoop.hive

Hive学习笔记 --- return code 1 from org.apache.hadoop.hive
  • u012965373
  • u012965373
  • 2016-12-13 12:36
  • 2448

程序中执行hive sql出错[FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask]

运行SQL时出了个错: SQL: INSERT OVERWRITE DIRECTORY 'result/testConsole' select count(1) from nutable;  ...
  • kexinmei
  • kexinmei
  • 2015-01-12 09:17
  • 9065

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask

hive> select count(1) from customer; Query ID = hive_20151113120000_368645da-6763-4ca3-a774-8961d49...
  • wuzhilon88
  • wuzhilon88
  • 2015-11-13 12:15
  • 7372

hive中删除表的错误Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException

hive中删除表的错误Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException FAILED: E...
  • wind520
  • wind520
  • 2014-09-09 23:51
  • 27361

Hive on Tez部署及验证测试

该帖子主要记录Hive On Tez安装及验证测试,并详细记录验证过程中的各种坑,具体坑如下: org/apache/hadoop/mapred/MRVersion java.lang.NoSuchM...
  • hqwang4
  • hqwang4
  • 2017-06-04 22:13
  • 1255

编译cocos2d项目出错

编译cocos2d项目出错 运行 cocos run -p android 报错内容如下: [dx] UNEXPECTED TOP-LEVEL EXCEPTION: [dx...
  • lllkey
  • lllkey
  • 2014-03-21 22:12
  • 5839