question Re: SelectHiveQL Fails on java.lang.NullPointerException in Archives of Support Questions (Read Only)

SelectHiveQL Fails on java.lang.NullPointerException

leroy_p33 — Sun, 18 Aug 2019 12:05:55 GMT

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 ?

Re: SelectHiveQL Fails on java.lang.NullPointerException

bbende — Mon, 19 Sep 2016 21:16:01 GMT

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

Re: SelectHiveQL Fails on java.lang.NullPointerException

leroy_p33 — Sun, 18 Aug 2019 12:05:42 GMT

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

Re: SelectHiveQL Fails on java.lang.NullPointerException

TimothySpann — Mon, 19 Sep 2016 22:11:47 GMT

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?

Re: SelectHiveQL Fails on java.lang.NullPointerException

TimothySpann — Mon, 19 Sep 2016 22:21:23 GMT

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?

Re: SelectHiveQL Fails on java.lang.NullPointerException

leroy_p33 — Tue, 20 Sep 2016 03:51:35 GMT

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)

Re: SelectHiveQL Fails on java.lang.NullPointerException

TimothySpann — Tue, 20 Sep 2016 04:37:44 GMT

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.

Re: SelectHiveQL Fails on java.lang.NullPointerException

mburgess — Tue, 20 Sep 2016 04:55:48 GMT

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.

Re: SelectHiveQL Fails on java.lang.NullPointerException

stamilibrahim — Thu, 17 Aug 2017 17:54:14 GMT

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.