Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Having trouble configuring hive odbc driver - SASL for Authentication

avatar
New Contributor

Hi,

While trying to configure the odbc driver, I get the following error:

Driver Version: V2.0.5.1005
Running connectivity tests...
Attempting connection
Failed to establish connection
SQLSTATE: HY000[Hortonworks][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT. The connection has been configured to use a SASL mechanism for authentication. This error might be due to the server is not using SASL for authentication
TESTS COMPLETED WITH ERROR.

Does anyone know how to go about this. Appreciate your help.

Thanks

1 ACCEPTED SOLUTION

avatar

Could you please validate your endpoints and make sure all the hostnames are correct?

If your env. is kerberized, then your ODBC Driver config file should a similar DSN as follows:

Description=Hortonworks Hive ODBC Driver DSN
Driver=/usr/lib/hive/lib/native/Linux-i386-32/libhortonworkshiveodbc32.so
DriverUnicodeEncoding=1
HOST=hive.example.com
PORT=10000
Schema=default
FastSQLPrepare=0
UseNativeQuery=0
HiveServerType=2
AuthMech=1
KrbHostFQDN=kdc.example.com
KrbServiceName=hive
KrbRealm=EXAMPLE.COM
UID=test

Could you share your ODBC configuration?

View solution in original post

4 REPLIES 4

avatar

Could you please validate your endpoints and make sure all the hostnames are correct?

If your env. is kerberized, then your ODBC Driver config file should a similar DSN as follows:

Description=Hortonworks Hive ODBC Driver DSN
Driver=/usr/lib/hive/lib/native/Linux-i386-32/libhortonworkshiveodbc32.so
DriverUnicodeEncoding=1
HOST=hive.example.com
PORT=10000
Schema=default
FastSQLPrepare=0
UseNativeQuery=0
HiveServerType=2
AuthMech=1
KrbHostFQDN=kdc.example.com
KrbServiceName=hive
KrbRealm=EXAMPLE.COM
UID=test

Could you share your ODBC configuration?

avatar

Hi @Jonas Straub

My env. is kerberized I am able to successfully connect through authentication mechanism "Kerberos" . When i am trying to use authentication mechanism "User Name" I get following error -

[Hortonworks][ThriftExtension] (2) Error occured during authentication.

How can I resolve this issue ? Thanks!

avatar
New Contributor

Hi Somya Pandey,

Could you please tell if you are able to resolve your issue.. and the resolution steps if so. Thanks.

avatar
Contributor
@Somya Pandey

did this ever get resolved for you. Please share your resolution, if so. thanks.