phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pranav Manwatkar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4738) Querying in LLAP failing using Phoenix Storage Handler
Date Mon, 14 May 2018 11:18:00 GMT
Pranav Manwatkar created PHOENIX-4738:
-----------------------------------------

             Summary: Querying in LLAP failing using Phoenix Storage Handler
                 Key: PHOENIX-4738
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4738
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
         Environment: OS: RHEL 7 (x64)
Hadoop version: Hadoop 2.7.3.2.6.2.0-205
Hive version: Hive 2.1.0.2.6.2.0-205
            Reporter: Pranav Manwatkar


We tried running this with hiveserver2 and it ran perfectly fine.

But when we try to run this with LLAP it is failing with the following error:


{code:java}
    ERROR : Status: Failed 
ERROR : Vertex failed, vertexName=Map 1, vertexId=vertex_1515391666274_0040_8_00, diagnostics=[Vertex
vertex_1515391666274_0040_8_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex
Input: t12_test initializer failed, vertex=vertex_1515391666274_0040_8_00 [Map 1], java.lang.NoSuchMethodError:
org.apache.hadoop.hive.serde2.ColumnProjectionUtils.getReadColumnNames(Lorg/apache/hadoop/conf/Configuration;)Ljava/util/List;

at org.apache.phoenix.hive.mapreduce.PhoenixInputFormat.getSplits(PhoenixInputFormat.java:123)

at org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:446)

at org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:569) 
at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:196)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:278)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:269)

at java.security.AccessController.doPrivileged(Native Method) 
at javax.security.auth.Subject.doAs(Subject.java:422) 
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) 
at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:269)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253)

at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
at java.lang.Thread.run(Thread.java:745) 
] 
ERROR : Vertex killed, vertexName=Reducer 2, vertexId=vertex_1515391666274_0040_8_01, diagnostics=[Vertex
received Kill in INITED state., Vertex vertex_1515391666274_0040_8_01 [Reducer 2] killed/failed
due to:OTHER_VERTEX_FAILURE] 
ERROR : DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:1 
INFO : org.apache.tez.common.counters.DAGCounter: 
INFO : AM_CPU_MILLISECONDS: 50 
INFO : AM_GC_TIME_MILLIS: 0 
ERROR : FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask.
Vertex failed, vertexName=Map 1, vertexId=vertex_1515391666274_0040_8_00, diagnostics=[Vertex
vertex_1515391666274_0040_8_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex
Input: t12_test initializer failed, vertex=vertex_1515391666274_0040_8_00 [Map 1], java.lang.NoSuchMethodError:
org.apache.hadoop.hive.serde2.ColumnProjectionUtils.getReadColumnNames(Lorg/apache/hadoop/conf/Configuration;)Ljava/util/List;

at org.apache.phoenix.hive.mapreduce.PhoenixInputFormat.getSplits(PhoenixInputFormat.java:123)

at org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:446)

at org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:569) 
at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:196)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:278)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:269)

at java.security.AccessController.doPrivileged(Native Method) 
at javax.security.auth.Subject.doAs(Subject.java:422) 
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) 
at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:269)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253)

at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
at java.lang.Thread.run(Thread.java:745) 
]Vertex killed, vertexName=Reducer 2, vertexId=vertex_1515391666274_0040_8_01, diagnostics=[Vertex
received Kill in INITED state., Vertex vertex_1515391666274_0040_8_01 [Reducer 2] killed/failed
due to:OTHER_VERTEX_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:1

INFO : Resetting the caller context to HIVE_SSN_ID:fd9bec2b-ce90-4b9d-a05b-24fd0acd6f5c 
INFO : Completed executing command(queryId=hive_20180115081200_84284ff0-034f-4dab-909f-359d56b76d95);
Time taken: 2.138 seconds 
Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask.
Vertex failed, vertexName=Map 1, vertexId=vertex_1515391666274_0040_8_00, diagnostics=[Vertex
vertex_1515391666274_0040_8_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex
Input: t12_test initializer failed, vertex=vertex_1515391666274_0040_8_00 [Map 1], java.lang.NoSuchMethodError:
org.apache.hadoop.hive.serde2.ColumnProjectionUtils.getReadColumnNames(Lorg/apache/hadoop/conf/Configuration;)Ljava/util/List;

at org.apache.phoenix.hive.mapreduce.PhoenixInputFormat.getSplits(PhoenixInputFormat.java:123)

at org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:446)

at org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:569) 
at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:196)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:278)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:269)

at java.security.AccessController.doPrivileged(Native Method) 
at javax.security.auth.Subject.doAs(Subject.java:422) 
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) 
at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:269)

at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253)

at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
at java.lang.Thread.run(Thread.java:745) 
]Vertex killed, vertexName=Reducer 2, vertexId=vertex_1515391666274_0040_8_01, diagnostics=[Vertex
received Kill in INITED state., Vertex vertex_1515391666274_0040_8_01 [Reducer 2] killed/failed
due to:OTHER_VERTEX_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:1
(state=08S01,code=2) {code}


We have also tried adding up the following jars and that has also not helped us in fixing
this issue. After adding up these jars we are hitting a new issue and the error is as below:


{code:java}

    Status: Failed
Vertex failed, vertexName=Map 1, vertexId=vertex_1523430199450_0010_1_00, diagnostics=[Task
failed, taskId=task_1523430199450_0010_1_00_000009, diagnostics=[TaskAttempt 0 failed, info=[Error:
Error while running task ( failure ) : attempt_1523430199450_0010_1_00_000009_0:java.lang.RuntimeException:
java.lang.RuntimeException: java.io.IOException: java.lang.RuntimeException: java.sql.SQLException:
No suitable driver found for jdbc:phoenix<zookeeper qourom>:2181:/hbase-secure;
	at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:218)
	at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:172)
	at org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:370)
	at org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:73)
	at org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:61)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:422)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866)
	at org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:61)
	at org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:37)
	at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36)
	at org.apache.hadoop.hive.llap.daemon.impl.StatsRecordingThreadPool$WrappedCallable.call(StatsRecordingThreadPool.java:110)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: java.io.IOException: java.lang.RuntimeException: java.sql.SQLException:
No suitable driver found for jdbc:phoenix<zookeeper qourom>:2181:/hbase-secure;{code}





--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message