phoenix-dev mailing list archives

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

    [ https://issues.apache.org/jira/browse/PHOENIX-4738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16474778#comment-16474778
] 

Josh Elser commented on PHOENIX-4738:
-------------------------------------

[~pranavmanwatkar], looks like you have conflicting versions of Hive jars on the classpath.
{code:java}
java.lang.NoSuchMethodError: org.apache.hadoop.hive.serde2.ColumnProjectionUtils.getReadColumnNames(Lorg/apache/hadoop/conf/Configuration;)Ljava/util/List;{code}

> 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
>            Priority: Major
>
> 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