Support Questions
Find answers, ask questions, and share your expertise

Having trouble configuring Hive ODBC

Highlighted

Having trouble configuring Hive ODBC

New Contributor

We have a newly installed Kerberized cluster, and I seem to have some type of local issue with my ODBC connection. I've got the MIT client, have a freshly renewed ticket, and am connecting via http as the Thrift transport. My colleagues seem to make the connection OK, I am using identical configuration settings -- but I get two requests to renew the ticket when I attempt to test the connection, and then I get this error back:

Failed to establish connection SQLSTATE: HY000[Hortonworks][Support] (50360) Integrated security authentication failed. (Routine Error: Unspecified GSS failure. Minor code may provide more information Mechanism Info: No credentials cache found Major: 851968 Minor: 2529639107

Any hints on where the error might be coming in would be greatly appreciated. Thanks!

2 REPLIES 2
Highlighted

Re: Having trouble configuring Hive ODBC

@Wendy Foslien

See this

Unspecified GSS failure. Minor code may provide more information Mechanism Info: No credentials cache found Major: 851968 Minor: 2529639107

See this http://research.imb.uq.edu.au/~l.rathbone/ldap/gssapi.shtml

You dont have the ticket. Please make sure that MIT client did issue the ticket for HS2

Re: Having trouble configuring Hive ODBC

Contributor