[NIFI-4808] Issue while executing putHiveSQL processor in non kerborized environment

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.3.0
• Component/s: Core Framework
• Environment: sandbox
• Assignee: Unassigned
• Reporter: RAVINDRA
• Created: 23/Jan/18 20:16
• Updated: 23/Jan/18 20:34
• Resolved: 23/Jan/18 20:34

Description

2018-01-23 19:00:10,568 INFO [Timer-Driven Process Thread-9] o.a.nifi.dbcp.hive.HiveConnectionPool HiveConnectionPool[id=16e42a53-c388-39a9-7748-19aa2c469dd1] Simple Authentication
2018-01-23 19:00:10,568 INFO [Timer-Driven Process Thread-9] org.apache.hive.jdbc.Utils Supplied authorities: ip-10-213-128-111.us-east-2.compute.internal:2181,ip-10-213-128-108.us-east-2.compute.internal:2181,ip-10-213-128-25.us-east-2.compute.internal:2181
2018-01-23 19:00:10,569 INFO [Timer-Driven Process Thread-9] o.a.c.f.imps.CuratorFrameworkImpl Starting
2018-01-23 19:00:10,573 INFO [Timer-Driven Process Thread-9-EventThread] o.a.c.f.state.ConnectionStateManager State change: CONNECTED
2018-01-23 19:00:10,575 INFO [Timer-Driven Process Thread-9] o.a.hive.jdbc.ZooKeeperHiveClientHelper Selected HiveServer2 instance with uri: hive.server2.authentication=NONE;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=ip-10-213-128-45.us-east-2.compute.internal;hive.server2.thrift.port=10000;hive.server2.use.SSL=false
2018-01-23 19:00:10,575 INFO [Curator-Framework-0] o.a.c.f.imps.CuratorFrameworkImpl backgroundOperationsLoop exiting
2018-01-23 19:00:10,576 INFO [Timer-Driven Process Thread-9] org.apache.hive.jdbc.Utils Resolved authority: hive.server2.authentication=NONE;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=ip-10-213-128-45.us-east-2.compute.internal;hive.server2.thrift.port=10000;hive.server2.use.SSL=false
2018-01-23 19:00:10,577 INFO [Timer-Driven Process Thread-9] org.apache.hive.jdbc.HiveConnection Will try to open client transport with JDBC Uri: jdbc:hive2://hive.server2.authentication=NONE;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=ip-10-213-128-45.us-east-2.compute.internal;hive.server2.thrift.port=10000;hive.server2.use.SSL=false/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
2018-01-23 19:00:10,577 ERROR [Timer-Driven Process Thread-9] o.apache.nifi.processors.hive.PutHiveQL PutHiveQL[id=53fbad01-0561-3977-c561-9749207ceff7] Failed to execute due to java.lang.NullPointerException: java.lang.NullPointerException
java.lang.NullPointerException: null
at org.apache.thrift.transport.TSocket.open(TSocket.java:170)
at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:266)
at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)
at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:204)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:176)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.apache.nifi.dbcp.hive.HiveConnectionPool.getConnection(HiveConnectionPool.java:298)
at sun.reflect.GeneratedMethodAccessor507.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.nifi.controller.service.StandardControllerServiceInvocationHandler.invoke(StandardControllerServiceInvocationHandler.java:89)
at com.sun.proxy.$Proxy124.getConnection(Unknown Source)
at org.apache.nifi.processors.hive.PutHiveQL.lambda$new$8(PutHiveQL.java:183)
at org.apache.nifi.processor.util.pattern.Put.onTrigger(Put.java:96)
at org.apache.nifi.processors.hive.PutHiveQL.lambda$onTrigger$13(PutHiveQL.java:255)
at org.apache.nifi.processor.util.pattern.PartialFunctions.onTrigger(PartialFunctions.java:114)
at org.apache.nifi.processor.util.pattern.RollbackOnFailure.onTrigger(RollbackOnFailure.java:184)
at org.apache.nifi.processors.hive.PutHiveQL.onTrigger(PutHiveQL.java:255)
at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1120)
at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:147)
at org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47)
at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:132)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2018-01-23 19:00:10,577 ERROR [Timer-Driven Process Thread-9] o.apache.nifi.processors.hive.PutHiveQL PutHiveQL[id=53fbad01-0561-3977-c561-9749207ceff7] org.apache.nifi.processors.hive.PutHiveQL$$Lambda$353/96722931@663e28c failed to process due to java.lang.RuntimeException: Failed to execute due to java.lang.NullPointerException; rolling back session: {}
java.lang.RuntimeException: Failed to execute due to java.lang.NullPointerException

Issue Links

• duplicates: NIFI-2575 HiveQL Processors Fail due to invalid JDBC URI resolution when using Zookeeper URI