KNOWLEDGE BASE

Error "Unexpected response received from server" When Refreshing a Hortonworks Hive Extract


Published: 06 May 2021
Last Modified Date: 10 May 2021

Issue

When creating or refreshing an extract of a Hortonworks Hive data source, a "Reconnect to" dialog may appear. Clicking 'Yes' on the dialog may result in the following error:

[Hortonworks][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.

Environment

  • Tableau Desktop
  • Hortonworks Hadoop Hive

Resolution

Enable the AutoReconnect option using the attached .tdc file, so that the Hive driver attempts to automatically reconnect to the server when a communication link error occurs.

Cause

When Tableau Desktop connects to Hortonworks Hive, the AutoReconnect option is set to 0 by default, because this option is incompatible with Kerberos constrained delegation on Tableau Server.
Did this article resolve the issue?