SelectHiveQL Fails on java.lang.NullPointerException

[#1]

Hi, this is my configuration for a SelectHiveQL processor in Nifi , my database connection url is :

jdbc:hive2:/************:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

And i have this error :

I tried to change output format but nothing changes,

Somebody can help me ?

[#2]

Can you look in nifi-home/logs/nifi-app.log to see if there is a stacktrace that goes with that error?

[#3]

There is nothing in the nifi-app.log that goes with this error, only this java Exception : @Bryan Bende

[#4]

this is probably bad SQL returning NULL killing Java. Test that query from CLI or try another query. Is there data in that table? does that query return any values?

[#5]

does the query run in beeline or ambari hive view or zeppelin?

is there data in the table?

It seems like CAST on null may be an issue.

does the user used by NiFi to access Hive have permissions to that table?

is your Hive connection pool in NiFi setup and working?

[#6]

Does not metter my query, even a "Select *" i have the same issue. I will check for the permissions.

How i could check if my Hive connection pool is working ? (i have no logs about this or error message)

[#7]

Under Process Group Configuration

look for a triangle next to HiveConnectionPool. if you enabled it and there's no warning, you are good. also check the bulletin board for error message or ..nifi/log/ log files.

[#8 · Accepted solution]

This is a known issue with the version of Hive (1.2.1) currently packaged with NiFi:

https://issues.apache.org/jira/browse/NIFI-2575

caused by:

https://issues.apache.org/jira/browse/HIVE-11581

The workaround is to not use Zookeeper for the service discovery.

[#9]

How do you not use Zookeeper for service discovery. Please give me step by step instructions if possible. Tried all recommended methods online with no luck. Thank you.