question Re: Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception in Support Questions

Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

VijaySankar — Mon, 20 Jan 2020 09:24:45 GMT

I am using SelectHive3QL processor in my Nifi flow and it is throwing a below Kerberos authentication exception. Initially it is working fine for some time and after some Idle time, getting a below error. My requirement is "SelectHive3QL" should always up and running without any issues.

Exception:

SelectHive3QL[id=47753131-0b9a-39c4-b0e7-2a92ac1042c6] Issue processing SQL select * from egress_test where service_name = 'NDC' due to java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: GSS initiate failed.: org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: GSS initiate failed

Cc: @MattWho , @arunak , @stevenmatison

Re: Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

DennisJaheruddi — Mon, 20 Jan 2020 17:44:02 GMT

Are you running a recent version of HDF?

This thread suggests it may be an issue that has been resolved: http://apache-nifi.1125220.n5.nabble.com/Hive-w-Kerberos-Authentication-starts-failing-after-a-week-td23887.html

Re: Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

MattWho — Wed, 22 Jan 2020 21:03:44 GMT

@VijaySankar

What version of NiFi are your running?

It is extremely likely you have encountered following bug:
https://issues.apache.org/jira/browse/NIFI-6210

So if you are not running Apache NiFi 1.10 or newer, you are exposed to this bug specifically affecting the Hive 3 NiFi components.

Hope this helps,
Matt

Re: Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

VijaySankar — Thu, 23 Jan 2020 19:39:11 GMT

@MattWho Thanks for your response.

Our Nifi version is 1.7.

Re: Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

MattWho — Thu, 23 Jan 2020 19:48:56 GMT

@VijaySankar

So, it is very likely you are hitting that bug. If you have a support subscription with Cloudera, you can open a support ticket for a patched release of HDF 3.2.x based off Apache NiFi 1.7.

If not, your best bet is to upgrade to NiFi 1.10.

Thanks,

Matt

Please take a moment to accept any answers which answered/resolved your query.

Re: Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

VijaySankar — Thu, 23 Jan 2020 19:51:44 GMT

Will do. Thanks.