KNOWLEDGE BASE

Connecting to Kerberos Enabled Hortonworks Hadoop Hive With ZooKeeper Quorum


Published: 31 Jul 2018
Last Modified Date: 06 Aug 2018

Issue

When attempting to connect to a Kerberos enabled Hadoop Hive cluster with a ZooKeeper Quorum an error appears:

"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

Follow these steps:
  1. Ensure all three ZooKeeper Quorum IP addresses are entered with their ports, for example 127.0.0.1:443, separated by commas.
  2. Omit or remove the port from the Port input box.
  3. Enable a TDC file with ODBC connection strings set to the necessary values based on a successful ODBC DSN connection using the 64-bit driver.       
See below PDF for Hortonworks ODBC configuration and connection strings.

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?