This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
There was a linebreak on the host value. You probably copied the hostname from another source and it has a linebreak 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.
Test Result of DSN ODBC is SUCCESS!
On the DSN, do a select all on the host field, delete everything and type the host value manually.