Environment Details
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.
-
Alteryx Designer
-
Impala with Windows Kerberos Authentication
-
Database Version: 2.11.0-cdh6.0.0, ODBC Client Version: 2.06.07.1007
-
Simba Driver
-
Apache Impala Simba 2.6.7.10
Cause
The reason why the error occurs is that SSPI is not enabled.
Resolution
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.
Additional Resources