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.

ODBC error connecting to Hive with Kerberos configured

Solved Go to solution

ODBC error connecting to Hive with Kerberos configured

New Contributor

Hello,

I have setup Hive configured with Ranger.When I'm trying to configure the ODBC, I'm getting the below error.

Jul 08 00:48:36.432 INFO 5764 TETSaslClientTransport::SaslLoggingCallback: Realm callback found. The realm returned was: TEL1.AZURE.JPNAP.CORPINTRA.NET
Jul 08 00:48:36.432 INFO 5764 TETSaslClientTransport::SaslLoggingCallback: Kerberos principal: hiveranger/qazumjebdpXXX.corpintra.net@CORPINTRA.NET
Jul 08 00:48:36.451 DEBUG 5764 TETSaslClientTransport::SaslLoggingCallback: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Server not found in Kerberos database)
Jul 08 00:48:36.451 TRACE 5764 HardyTCLIServiceClient::~HardyTCLIServiceClient: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardyConnection::~HardyConnection: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardyConnection::Disconnect: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardyConnection::CleanUpConnEstablishThread: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardyHiveClientFactory::~HardyHiveClientFactory: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardySessionManager::~HardySessionManager: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardyHiveCxnPool::~HardyHiveCxnPool: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardyHiveCxnFactory::~HardyHiveCxnFactory: +++++ enter +++++
Jul 08 00:48:36.452 TRACE 5764 HardyHardyQuotedIDManager::~HardyHardyQuotedIDManager: +++++ enter +++++

Kindly let me know, if someone encountered this issue

Regards

1 ACCEPTED SOLUTION

Accepted Solutions

Re: ODBC error connecting to Hive with Kerberos configured

Hi @Srinivasan Govindasamy!
Are you able to connect to your kerberos database (host receiving this error)? If so, check if your /etc/krb5.conf > Realm or ambari kerberos configs match with the realm requested, as I can see they look a little bit different.
TEL1.AZURE.JPNAP.CORPINTRA.NET != hiveranger/qazumjebdpXXX.corpintra.net@CORPINTRA.NET

Also, check the ranger logs if you can find any issue as well :)

Hope this helps!

2 REPLIES 2

Re: ODBC error connecting to Hive with Kerberos configured

Hi @Srinivasan Govindasamy!
Are you able to connect to your kerberos database (host receiving this error)? If so, check if your /etc/krb5.conf > Realm or ambari kerberos configs match with the realm requested, as I can see they look a little bit different.
TEL1.AZURE.JPNAP.CORPINTRA.NET != hiveranger/qazumjebdpXXX.corpintra.net@CORPINTRA.NET

Also, check the ranger logs if you can find any issue as well :)

Hope this helps!

Re: ODBC error connecting to Hive with Kerberos configured

New Contributor

Hello @Vinicius Higa Murakami,

thanks for the reply. The issue is resolved now. I have wrongly used the AD FQDN under Host FQDN field.

also one more note, it was not working when i use different service name other than "hive"snapshot.gif

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