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.

ODBC connection impala with username and password

ODBC connection impala with username and password

Explorer

Hello,

 

I'm trying to connect to one of our DataNode imapala's deamon via ODBC (for SpotFire).

 

Works fine without creditentials but can't get it working with SASL: 

 

 

SQLSTATE: HY000[Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: Unknown: errno = 10053

I tried to connect with an unix user who belongs in impala group (Like I would with Hue)

 

Our cluster doesn't yet have Kerberos or LDAP that's why we're stuck with SASL for now.

 

I've tried with the Hive connector and were able to connect this way.

 

Any idea on what maybe wrong ? 

 

Many thanks,

Guillaume,

2 REPLIES 2

Re: ODBC connection impala with username and password

New Contributor

Did you solve this issue  ?

Re: ODBC connection impala with username and password

Explorer

Yes, we just unchecked SASL option from the ODBC configuration panel.