Accessing Clusters
Also available as:
PDF

Example: Tableau

Tableau is a business intelligence tool for interacting with and visualizing data via SQL. Connecting Tableau to Hive requires the use of an ODBC driver. In this example, we provide high-level steps required to set up Tableau to access Hive.

Prerequisite:

Download SSL certificate

Step 1: Install ODBC Driver

  1. Download the Hortonworks ODBC Driver for Apache Hive from https://hortonworks.com/downloads/#addons.
  2. Next, extract and install the driver.

Step 2: Launch Tableau and Connect to Hive

  1. Launch Tableau. If you do not already have Tableau, you can download a trial version from https://www.tableau.com/trial/download-tableau.
  2. In Tableau, create a connection to a “Hortonworks Hadoop Hive” server. Enter the following:
    Property Value
    Server Enter the public hostname of your controller node instance.
    Port 8443
    Type HiveServer2
    Authentication Username and Password
    Transport HTTP
    Username Enter the cluster username created when creating your cluster
    Password Enter the cluster password created when creating your cluster
    HTTP Path Provide "${CLUSTER_NAME}/${TOPOLOGY_NAME}/hive". For example hive-test/db-proxy/hive
  3. Check the Require SSL checkbox.
  4. Click on the text underneath the checkbox to add a configuration file link.
  5. Specify to use a custom SSL certificate, and then browse to the SSL certificate gateway.pem file that was generated when you downloaded the SSL certificate as a prerequisite.

  6. Click OK.

    After performing these steps, your configuration should look similar to:

  7. Click Sign In and you will be connected to Hive.