I'm trying to fire a basic SELECT query using SelectHiveQL processor but its throwing me a NullPointerException.
NiFi Version: 1.9.2
Hive Version: 220.127.116.11.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 ?