KNOWLEDGE BASE

Error "Unable to connect to the server" Connecting to Kerberos Enabled Hortonworks Hadoop Hive With ZooKeeper Quorum


Published: 31 Jul 2018
Last Modified Date: 02 Jan 2019

Issue

When attempting to connect to a Kerberos enabled Hadoop Hive cluster with a ZooKeeper Quorum, the following error occurs:

"An error occurred while communicating with Hortonworks Hadoop Hive.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database"

Environment

  • Tableau Desktop 
  • Hortonworks Hadoop Hive
  • Kerberos
  • Zookeeper Quorum

Resolution

  1. Navigate to the data source pane and select Edit Connection.
  2. In the Hortonworks Hadoop Hive dialog box, do the following:
    • In Server, enter all three ZooKeeper Quorum IP addresses are entered with their ports, separated by commas. For example: 
      127.0.0.1:443, 127.0.0.2:444, 127.0.1.0:445
    • In Port, remove any port information.
  3. Place the attached Hortonworks Zookeeper Quorum Sample TDC file in your My Tableau Repository\Datasources folder.
  4. Restart Tableau Desktop. 
If the attached sample TDC does not correct the connection issue, consult your database vendor's manual. 

Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files. 

Cause

  1. We are unable to directly connect to the database with this configuration.
  2. The native Hortonworks connector does not have the necessary connection strings to connect to this type of database configuration.
Did this article resolve the issue?