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.