Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

Solved Go to solution
Highlighted

Nifi - SelectHive3QL processor is throwing a Kerberos authentication exception

Explorer

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

Master Guru

@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.

View solution in original post

5 REPLIES 5
Highlighted

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

Expert Contributor

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-...


- Dennis Jaheruddin

If this answer helped, please mark it as 'solved' and/or if it is valuable for future readers please apply 'kudos'. Also check out my techincal portfolio at https://portfolio.jaheruddin.nl
Highlighted

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

Master Guru

@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

Highlighted

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

Explorer

@MattWho Thanks for your response.

 

Our Nifi version is 1.7.

Highlighted

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

Master Guru

@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.

View solution in original post

Highlighted

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

Explorer

Will do. Thanks.

Don't have an account?
Coming from Hortonworks? Activate your account here