Support Questions
Find answers, ask questions, and share your expertise

NIFI: NullPointerException when using SelectHiveQL Processor

NIFI: NullPointerException when using SelectHiveQL Processor

New Contributor

Hi,


I'm trying to fire a basic SELECT query using SelectHiveQL processor but its throwing me a NullPointerException.

108029-selecthiveql.png

nifi-app.log attached.

nifi-app.txt


System:

NiFi Version: 1.9.2

Hive Version: 3.1.0.3.0.1.0-187


I'm using zookeeper url for hive Jdbc connection. I'm able to connect to the hive server using the same zookeeper url using dBeaver

I have added core-site.xml and hive-site.xml under HiveConfigurationResources.


When I am connecting to HDP sandbox hive using NiFi it is working without any issues, however its a normal jdbc connection without any zookeeper.


I found a similar issue when trying to google for this. https://community.hortonworks.com/questions/57220/selecthiveql-fails-on-javalangnullpointerexception.... and a jira is open https://issues.apache.org/jira/browse/NIFI-2575


Is there a workaround for this till this is resolved ?


Thanks

Sri