hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kavan Suresh (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16235) Hive queries fail with return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
Date Thu, 16 Mar 2017 22:22:41 GMT
Kavan Suresh created HIVE-16235:
-----------------------------------

             Summary: Hive queries fail with return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
                 Key: HIVE-16235
                 URL: https://issues.apache.org/jira/browse/HIVE-16235
             Project: Hive
          Issue Type: Bug
            Reporter: Kavan Suresh


Simplified version for reproducing issue as provided by [~wzheng]
{code}
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
set hive.execution.engine=mr;
set hive.auto.convert.join=true;

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (c1 int, c2 int) clustered by (c1) into 10 buckets stored as orc;

INSERT INTO t1 VALUES (1, 2), (3, 4);

SELECT * FROM t1;

EXPLAIN
SELECT INPUT__FILE__NAME, t1.c1, t1.c2
FROM t1
INNER JOIN
(SELECT * FROM t1 WHERE t1.c1 = 1) sub
ON sub.c1 = t1.c1;

SELECT INPUT__FILE__NAME, t1.c1, t1.c2
FROM t1
INNER JOIN
(SELECT * FROM t1 WHERE t1.c1 = 1) sub
ON sub.c1 = t1.c1;
{code}

>From hiveserver2.log:
{noformat}
INFO  [HiveServer2-Background-Pool: Thread-694]: lockmgr.DbTxnManager (DbTxnManager.java:acquireLocks(207))
- Setting lock request transaction to txnid:58 for queryId=hive_20170314035259_6a38c0fa-3dcd-4ebf-abc2-6ad61f33e040
....
 [HiveServer2-Background-Pool: Thread-694]: ql.Driver (Driver.java:execute(1411)) - Starting
command(queryId=hive_20170314035259_6a38c0fa-3dcd-4ebf-abc2-6ad61f33e040): <query>
....
 ERROR [HiveServer2-Background-Pool: Thread-694]: exec.Task (SessionState.java:printError(993))
-
Task failed!
Task ID:
  Stage-15

Logs:
....
 ERROR [HiveServer2-Background-Pool: Thread-694]: ql.Driver (SessionState.java:printError(993))
- FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask

{noformat}

There are no failed jobs on the RM UI, the MapredLocalTask log shows the below error: 

{noformat}
ERROR mr.MapredLocalTask (MapredLocalTask.java:executeInProcess(356)) - Hive Runtime Error:
Map local work failed
java.lang.NullPointerException
        at org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.initialize(ExprNodeColumnEvaluator.java:56)
        at org.apache.hadoop.hive.ql.exec.JoinUtil.getObjectInspectorsFromEvaluators(JoinUtil.java:77)
        at org.apache.hadoop.hive.ql.exec.HashTableSinkOperator.initializeOp(HashTableSinkOperator.java:147)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:363)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:482)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:439)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:376)
        at org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.initializeOperators(MapredLocalTask.java:461)
        at org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.startForward(MapredLocalTask.java:365)
        at org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.executeInProcess(MapredLocalTask.java:345)
        at org.apache.hadoop.hive.ql.exec.mr.ExecDriver.main(ExecDriver.java:744)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.apache.hadoop.util.RunJar.run(RunJar.java:233)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:148)
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message