[Cloudera][DriverSupport] (1170): Not able to connect Cloudera to Alteryx

[samsxr]

I am trying to connect Impala Cloudera to Alteryx and getting below error.

Internal Error SQLDriverConnect: [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.

in ODBC driver, the connection test is successful, it also works in Power BI (I am able to fetch data into Power BI using the same ODBC settings). Here is what I have tried so far;

1. deleted Host name and port number and typed the same

2. tried uninstalling and reinstalling Alteryx designer

3. tried reverting to an older version of Alteryx designer.

However, nothing seems to work. getting the same error over and over again.

[Deano478]

@samsxr have you tried to use the telnet command in the cmd if your on windows to test connectivity it would be something like: 

telnet <Impala Host IP> <port No.>

also have you tried putting in the IP Address as the hostname?

[samsxr]

tried putting in the IP address as hostname, didn't work. by doing that, the ODBC test connection also fails (which otherwise is successful with the original hostname).

Also, cmd says 'telnet is not recognized as an internal or external command'