hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "q79969786 (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-8482) set hive.auto.convert.join=true has a bug when create table as select with join
Date Thu, 16 Oct 2014 08:46:34 GMT

     [ https://issues.apache.org/jira/browse/HIVE-8482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

q79969786 updated HIVE-8482:
----------------------------
          Description: 
014-10-16 16:37:22,899 Stage-31 map = 0%,  reduce = 0%
2014-10-16 16:38:19,081 Stage-31 map = 100%,  reduce = 100%
Ended Job = job_201409101641_249763 with errors
Error during job, obtaining debugging information...
Job Tracking URL: http://CNSH041566.app.paic.com.cn:50030/jobdetails.jsp?user.name=hadoop&jobid=job_201409101641_249763
Examining task ID: task_201409101641_249763_m_000002 (and more) from job job_201409101641_249763

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

URL:
  http://CNSH041566.app.paic.com.cn:50030/taskdetails.jsp?jobid=job_201409101641_249763&tipid=task_201409101641_249763_m_000000
-----
Diagnostic Messages for this Task:
java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.FileNotFoundException:
/data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/-5448139015889594124_-2045333338_404393650/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_16-33-51_335_4584605482989653833-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
        at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:195)
        at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
        at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:366)
        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:1190)
        at org.apache.hadoop.mapred.Child.main(Child.java:249)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.FileNotFoundException:
/data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/-5448139015889594124_-2045333338_404393650/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_16-33-51_335_4584605482989653833-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
        at org.apache.hadoop.hive.ql.exec.mr.HashTableLoader.load(HashTableLoader.java:104)
        at org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable(MapJoinOperator.java:152)
        at org.apache.hadoop.hive.ql.exec.MapJoinOperator.cleanUpInputFileChangedOp(MapJoinOperator.java:178)
        at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1029)
        at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1033)
        at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1033)
        at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:505)
        at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:177)
        ... 8 more
Caused by: java.io.FileNotFoundException: /data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/-5448139015889594124_-2045333338_404393650/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_16-33-51_335_4584605482989653833-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:120)
        at java.io.FileInputStream.<init>(FileInputStream.java:79)
        at org.apache.hadoop.hive.ql.exec.mr.HashTableLoader.load(HashTableLoader.java:95)
        ... 15 more


FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
MapReduce Jobs Launched: 

  was:
java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.FileNotFoundException:
/data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/4554609282698230126_-1275563112_394094114/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_13-42-26_451_2739170706811325303-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:195)
	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:366)
	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:1190)
	at org.apache.hadoop.mapred.Child.main(Child.java:249)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.FileNotFoundException:
/data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/4554609282698230126_-1275563112_394094114/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_13-42-26_451_2739170706811325303-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
	at org.apache.hadoop.hive.ql.exec.mr.HashTableLoader.load(HashTableLoader.java:104)
	at org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable(MapJoinOperator.java:152)
	at org.apache.hadoop.hive.ql.exec.MapJoinOperator.cleanUpInputFileChangedOp(MapJoinOperator.java:178)
	at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1029)
	at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1033)
	at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1033)
	at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:505)
	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:177)
	... 8 more
Caused by: java.io.FileNotFoundException: /data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/4554609282698230126_-1275563112_394094114/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_13-42-26_451_2739170706811325303-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
	at java.io.FileInputStream.open(Native Method)
	at java.io.FileInputStream.<init>(FileInputStream.java:120)
	at java.io.FileInputStream.<init>(FileInputStream.java:79)
	at org.apache.hadoop.hive.ql.exec.mr.HashTableLoader.load(HashTableLoader.java:95)
	... 15 more


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

    Affects Version/s: 0.12.0
              Summary: set hive.auto.convert.join=true has a bug when create table as select
with join  (was: hive HashTableLoader error)

> set hive.auto.convert.join=true has a bug when create table as select with join
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-8482
>                 URL: https://issues.apache.org/jira/browse/HIVE-8482
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.12.0
>            Reporter: q79969786
>
> 014-10-16 16:37:22,899 Stage-31 map = 0%,  reduce = 0%
> 2014-10-16 16:38:19,081 Stage-31 map = 100%,  reduce = 100%
> Ended Job = job_201409101641_249763 with errors
> Error during job, obtaining debugging information...
> Job Tracking URL: http://CNSH041566.app.paic.com.cn:50030/jobdetails.jsp?user.name=hadoop&jobid=job_201409101641_249763
> Examining task ID: task_201409101641_249763_m_000002 (and more) from job job_201409101641_249763
> Task with the most failures(4): 
> -----
> Task ID:
>   task_201409101641_249763_m_000000
> URL:
>   http://CNSH041566.app.paic.com.cn:50030/taskdetails.jsp?jobid=job_201409101641_249763&tipid=task_201409101641_249763_m_000000
> -----
> Diagnostic Messages for this Task:
> java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.FileNotFoundException:
/data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/-5448139015889594124_-2045333338_404393650/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_16-33-51_335_4584605482989653833-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
>         at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:195)
>         at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
>         at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430)
>         at org.apache.hadoop.mapred.MapTask.run(MapTask.java:366)
>         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:1190)
>         at org.apache.hadoop.mapred.Child.main(Child.java:249)
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.FileNotFoundException:
/data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/-5448139015889594124_-2045333338_404393650/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_16-33-51_335_4584605482989653833-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
>         at org.apache.hadoop.hive.ql.exec.mr.HashTableLoader.load(HashTableLoader.java:104)
>         at org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable(MapJoinOperator.java:152)
>         at org.apache.hadoop.hive.ql.exec.MapJoinOperator.cleanUpInputFileChangedOp(MapJoinOperator.java:178)
>         at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1029)
>         at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1033)
>         at org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1033)
>         at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:505)
>         at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:177)
>         ... 8 more
> Caused by: java.io.FileNotFoundException: /data/data01/data/tmp/hadoop-hadoop/mapred/local/taskTracker/hduser0401/distcache/-5448139015889594124_-2045333338_404393650/CNSH041566.app.paic.com.cn/tmp/hduser0401/hive_2014-10-16_16-33-51_335_4584605482989653833-1/-mr-10024/HashTable-Stage-31/Stage-31.tar.gz/MapJoin-mapfile21--.hashtable
(No such file or directory)
>         at java.io.FileInputStream.open(Native Method)
>         at java.io.FileInputStream.<init>(FileInputStream.java:120)
>         at java.io.FileInputStream.<init>(FileInputStream.java:79)
>         at org.apache.hadoop.hive.ql.exec.mr.HashTableLoader.load(HashTableLoader.java:95)
>         ... 15 more
> FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
> MapReduce Jobs Launched: 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message