MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / Error (1170) Unexpected response received from server. Please ensure the server host and port s...
Error (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) when using HIVE ODBC Connection
user

Created/Edited - 4/29/2026 by Nora Tobon | Alteryx

Summary
"Error (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) " when using HIVE ODBC Connection
Issue

When connecting to Hive to pull data into the Input Data tool via ODBC, the following error occurs:
 

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


 

Environment
  • Alteryx Designer
    • All Versions.
  • Hive ODBC
    • Cloudera ODBC Driver for Apache Hive Driver version: 2.6.1.1001
 
Cause

There was a line break on the host value. You probably copied the hostname from another source, and it has a line break from that source that isn't appearing. 

If you open the ODBC log in Notepad++ and click on 'Show All Characters,' you will see the linebreak (LF) at the beginning of the host value.

 

 
Resolution

Diagnosis 

Test Result of DSN ODBC is SUCCESS!
 

Solution

On the DSN, do a select all on the host field, delete everything and type the host value manually. 


 


 

Was this article helpful?