The following error is seen when users run a workflow that connects to a Hadoop Impala instance with Kerberos enabled.
ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
Impala with Windows Kerberos Authentication
Database Version: 2.11.0-cdh6.0.0, ODBC Client Version: 2.06.07.1007
Apache Impala Simba 184.108.40.206
The reason why the error occurs is that SSPI is not enabled.
If you are using Windows Kerberos authentication (via SSPI), you must select the "Use Only SSPI - Enable for this DSN" option within the Simba Impala ODBC driver Advanced Options.