Having trouble configuring hive odbc driver - SASL for Authentication

[#1]

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

[#2 · Accepted solution]

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?

[#3]

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!

[#4]

Hi Somya Pandey,

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

[#5]

@Somya Pandey

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