hive执行插入数据(insert....)时报错

2014-01-28 02:59:33 1.8k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【图文详细】Hive的DML操作中Insert 插入数据语法结构： 1、插入一条数据： INSERT INTO TABLE table_name VALUES(XX,YY,ZZ); 2、利用查询语句将结果导入新表： INSERT OVERWRITE [INTO] TABLE table_name [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1 FROM fro... 阅读详情

2014-01-28 10:25:35,230 Stage-0 map = 0%, reduce = 0%
2014-01-28 10:26:02,670 Stage-0 map = 100%, reduce = 100%
Ended Job = job_201401241752_0013 with errors
Error during job, obtaining debugging information...
Job Tracking URL: http://Master:50030/jobdetails.jsp?jobid=job_201401241752_0013
Examining task ID: task_201401241752_0013_m_000002 (and more) from job job_201401241752_0013

Task with the most failures(4):
-----
Task ID:
task_201401241752_0013_m_000000

URL:
http://Master:50030/taskdetails.jsp?jobid=job_201401241752_0013&tipid=task_201401241752_0013_m_000000
-----
Diagnostic Messages for this Task:
java.lang.RuntimeException: Error in configuring object
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:75)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:413)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332)
at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)
at org.apache.hadoop.mapred.Child.main(Child.java:262)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
MapReduce Jobs Launched:
Job 0: Map: 1 HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec

这是什么问题呢？

...全文