You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Joe Travaglini (JIRA)" <ji...@apache.org> on 2013/09/17 14:24:53 UTC
[jira] [Commented] (HIVE-4605) hive job fails when insert overwrite
ORC table
[ https://issues.apache.org/jira/browse/HIVE-4605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13769472#comment-13769472 ]
Joe Travaglini commented on HIVE-4605:
--------------------------------------
Brock,
I've also been seeing this same symptom several times over the past month, but with RCFile and not ORC.
I also cannot reliably reproduce, but it's happening.
See also http://mail-archives.apache.org/mod_mbox/hive-user/201306.mbox/%3CCANsfGRkR0jy5W3eY3z8aWTWpypHGu5YeDicybVJBnwR_o_52Vg@mail.gmail.com%3E which seems like the same symptom.
Hive 0.10 in CDH4.3.1
> hive job fails when insert overwrite ORC table
> ----------------------------------------------
>
> Key: HIVE-4605
> URL: https://issues.apache.org/jira/browse/HIVE-4605
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.11.0
> Environment: OS: 2.6.18-194.el5xen #1 SMP Fri Apr 2 15:34:40 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
> Hadoop 1.1.2
> Reporter: Link Qian
> Assignee: Brock Noland
>
> 1, create a table with ORC storage model
> create table iparea_analysis_orc (network int, ip string, .... )
> stored as ORC;
> 2, insert table iparea_analysis_orc select network, ip, .... , the script success, but failed after add *OVERWRITE* keyword. the main error log list as here.
> ava.lang.RuntimeException: Hive Runtime Error while closing operators: Unable to rename output from: hdfs://qa3hop001.uucun.com:9000/tmp/hive-hadoop/hive_2013-05-24_15-11-06_511_7746839019590922068/_task_tmp.-ext-10000/_tmp.000000_0 to: hdfs://qa3hop001.uucun.com:9000/tmp/hive-hadoop/hive_2013-05-24_15-11-06_511_7746839019590922068/_tmp.-ext-10000/000000_0
> at org.apache.hadoop.hive.ql.exec.ExecReducer.close(ExecReducer.java:317)
> at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:530)
> at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:421)
> at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
> 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:1149)
> at org.apache.hadoop.mapred.Child.main(Child.java:249)
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to rename output from: hdfs://qa3hop001.uucun.com:9000/tmp/hive-hadoop/hive_2013-05-24_15-11-06_511_7746839019590922068/_task_tmp.-ext-10000/_tmp.000000_0 to: hdfs://qa3hop001.uucun.com:9000/tmp/hive-hadoop/hive_2013-05-24_15-11-06_511_7746839019590922068/_tmp.-ext-10000/000000_0
> at org.apache.hadoop.hive.ql.exec.FileSinkOperator$FSPaths.commit(FileSinkOperator.java:197)
> at org.apache.hadoop.hive.ql.exec.FileSinkOperator$FSPaths.access$300(FileSinkOperator.java:108)
> at org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:867)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:588)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:597)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:597)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:597)
> at org.apache.hadoop.hive.ql.exec.ExecReducer.close(ExecReducer.java:309)
> ... 7 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira