community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Error Connecting to Hadoop using hive odbc

Highlighted
Atom

While connecting hive through Hive ODBC i am getting the below error.

FAILED!

[Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Server not found in Kerberos database).

 

Kerberos is active and also kerberos ticket is also active

 

how to resolve this issue.

@bsantho3 

Have you set up your Kerberos credential cache and config file (krb5.conf)?

See this link:
https://www.simba.com/products/Hive/doc/ODBC_InstallGuide/win/content/odbc/hi/kerberos.htm

 

Atom

Thanks Patric. I had to close and restart the MIT Kerberos and Credential cache and then setup the Kerberos credential cache.

Krb5.conf was already available.

Finally it worked.

 

Thanks.

Labels