Friday, December 11, 2015

[Solved] Impala ODBC SASL Authentication Error

Attempting connection
Failed to establish connection
SQLSTATE: HY000[Cloudera][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT. The connection has been configured to use a SASL mechanism for authentication. Please check to see whether the server has been configured to use SASL for authentication

We came across this ODBC connectivity error while trying to connect to an Impala Data Source.

Cause: This cause of this error is that SASL Authentication has not been configured in the Impala Server. 

Resolution: This can be resolved easily by clicking Ok on the error and at the connection Information window uncheck the 'Use Simple Authentication and Security Layer(SASL)' option. 



Now Retest the connection and it will be working fine, provided you have given the correct credentials and connection details to Impala Server.



No comments:

Post a Comment