How to Connect To Hive Using ODBC in Tableau

Note: The ODBC connector is supported for Windows version of Tableau only.

1. Download Hortonworks driver from the link below
   https://hortonworks.com/downloads/#addons
   
   1. Chose Hortonworks ODBC Driver for Apache Hive (v2.1.10) from Hortonworks Data Platform Add-Ons section (Tested Windows 64 bit)
   2. Download and run/install the driver.
2. Create a Data Source Name in ODBC Administrator:
   1. Open Data Sources (ODBC) from Control Panel/Administrative Tools.
   2. Highlight "Sample Hortonworks Hive DSN" from System DSN tab and click "Configure" button
   3. Enter the following info
      1. Host(s): <HOST_NAME>
      2. Port: <PORT>
      3. Database: Default
      4. Mechanism: select "User name password" from dropdown
      5. User name: <USER_NAME>
      6. Password: <PASSWORD>
      7. Delegation UID:
      8. Thrift Transport: select "HTTP" from dropdown
   4. Click on HTTP Options
      1. HTTP Path: gateway/default/hive
   5. Click on SSL Options
      1. Check "Enable SSL" checkbox
      2. Check "Allow Common name host name mismatch" checkbox - This option specifies whether a CA-issued SSL certificate name must match the host name of the Hive server
      3. Trusted Certificates: The full path of the .pem file containing trusted CA certificates for verifying the server when using SSL.
   6. Click "Test" on the bottom of the dialog box to test
   7. Once successful, click "OK" button

From Tableau

1. On the Connect screen
   1. Click "More ..." from "To a Server" section
   2. Choose "Other Databases (ODBC)"
      1. DSN: Choose "Sample Hortonworks Hive DSN" from dropdown
      2. Click "Connect" button. (Once connected, "Connection Attributes" section will be activated/enabled)
   3. On the Connection Attributes Section
      1. Server: <HOST_NAME>
      2. Port: <PORT>
      3. Database: Default
      4. Username: <USER_NAME>
      5. Password: <PASSWORD>
      6. Click on "Sign In"