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.

Having trouble configuring hive odbc driver - SASL for Authentication

Solved Go to solution

Having trouble configuring hive odbc driver - SASL for Authentication

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

Accepted Solutions

Re: Having trouble configuring hive odbc driver - SASL for Authentication

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?

4 REPLIES 4

Re: Having trouble configuring hive odbc driver - SASL for Authentication

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?

Highlighted

Re: Having trouble configuring hive odbc driver - SASL for Authentication

New Contributor

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!

Re: Having trouble configuring hive odbc driver - SASL for Authentication

New Contributor

Hi Somya Pandey,

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

Re: Having trouble configuring hive odbc driver - SASL for Authentication

New Contributor
@Somya Pandey

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