Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

insert is not working on phoenix table from hive llap connection.

insert is not working on phoenix table from hive llap connection.

Hi I am using HDP 2.6.

I am getting No suitable error while doing insert into phoenix table through hive llap.

Please find error:- 

ERROR : Status: Failed
ERROR : Vertex failed, vertexName=Map 1, vertexId=vertex_1518677556019_0007_5_00, diagnostics=[Task failed, taskId=task_1518677556019_0007_5_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_0:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 1 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_1:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 2 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_2:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 3 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_3:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:0, Vertex vertex_1518677556019_0007_5_00 [Map 1] killed/failed due to:OWN_TASK_FAILURE]
ERROR : DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0
INFO  : org.apache.tez.common.counters.DAGCounter:
INFO  :    NUM_FAILED_TASKS: 4
INFO  :    TOTAL_LAUNCHED_TASKS: 4
INFO  :    AM_CPU_MILLISECONDS: 150
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_1518677556019_0007_5_00, diagnostics=[Task failed, taskId=task_1518677556019_0007_5_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_0:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 1 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_1:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 2 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_2:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 3 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_3:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:0, Vertex vertex_1518677556019_0007_5_00 [Map 1] killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0
INFO  : Resetting the caller context to HIVE_SSN_ID:beff635c-672c-4ce3-be0b-4f3e7eedf010
INFO  : Completed executing command(queryId=hive_20180215093836_9a35bc31-9d15-4e3c-8bdf-e1186eb2d6ec); Time taken: 2.346 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_1518677556019_0007_5_00, diagnostics=[Task failed, taskId=task_1518677556019_0007_5_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_0:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 1 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_1:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 2 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_2:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
], TaskAttempt 3 failed, info=[Error: Error while running task ( failure ) : attempt_1518677556019_0007_5_00_000000_3:java.lang.RuntimeException: java.lang.RuntimeException: Map operator initialization failed
        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: Map operator initialization failed
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:354)
        at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:188)
        ... 15 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:442)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:374)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:564)
        at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:516)
        at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:384)
        at org.apache.hadoop.hive.ql.exec.MapOperator.initializeMapOperator(MapOperator.java:443)
        at org.apache.hadoop.hive.ql.exec.tez.MapRecordProcessor.init(MapRecordProcessor.java:317)
        ... 16 more
Caused by: org.apache.hadoop.hive.serde2.SerDeException: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:82)
        at org.apache.phoenix.hive.PhoenixSerDe.initialize(PhoenixSerDe.java:86)
        at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:359)
        ... 25 more
Caused by: java.sql.SQLException: No suitable driver found for jdbc:phoenix:ip-192-168-180-204.ca-central-1.compute.internal,ip-192-168-180-27.ca-central-1.compute.internal,ip-192-168-180-230.ca-central-1.compute.internal:2181:/hbase-unsecure;
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:96)
        at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getInputConnection(PhoenixConnectionUtil.java:63)
        at org.apache.phoenix.hive.PhoenixSerializer.<init>(PhoenixSerializer.java:70)
        ... 27 more
]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:0, Vertex vertex_1518677556019_0007_5_00 [Map 1] killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0 (state=08S01,code=2)
5 REPLIES 5

Re: insert is not working on phoenix table from hive llap connection.

Super Collaborator

If I remember correctly, LLAP doesn't work with storage handlers. So you need to use tez engine to deal with phoenix tables.

Re: insert is not working on phoenix table from hive llap connection.

@Sergey Soldatov

I am already using Tez. Could you please help me to configure Tez with LLAP?

Or any document so I can walk through.

Re: insert is not working on phoenix table from hive llap connection.

Expert Contributor

AFAIK, Phoenix Handlers are compiled with Hive 1.x dependency, @Sergey Soldatov, are we supporting Phoenix Storage handlers in HS2Interactive / Hive 2.x ?

Re: insert is not working on phoenix table from hive llap connection.

New Contributor

very nice informational blog , Also this blog have a very nice articals and post . So i am create an account for get more information from this site in future . and also more information to go and click here .

Re: insert is not working on phoenix table from hive llap connection.

@priyank pandey

What is this blog? I am not getting anything in blog related to my query.

Don't have an account?
Coming from Hortonworks? Activate your account here