Cloudera Docs

Connecting to Hive Virtual Warehouses with Tableau

This topic describes how to connect to Tableau with Hive Virtual Warehouses on Cloudera Data Warehouse (CDW) service.

Before you can use Tableau with Hive Virtual Warehouses, you must have created a Database Catalog that is populated with data. You have the option to populate your Database Catalog with sample data when you create it. You must also create a Hive Virtual Warehouse, which is configured to connect to the Database Catalog that is populated with data.

  1. Download the latest version of the Hive ODBC driver from Cloudera Downloads page.
  2. Install the driver on the local host where you intend to use Tableau Desktop.
  3. Log in to the CDP web interface and navigate to the Data Warehouse service.
  4. In the Data Warehouse service, click Virtual Warehouse in the left navigation panel.
  5. On the Virtual Warehouses page, in the upper right corner of the tile for the Hive Virtual Warehouse you want to connect to, click the options menu, and select Copy JDBC URL. This copies the JDBC URL to your system's clipboard.
  6. Paste the copied JDBC URL into a text file. It should look similar to the following: 
    jdbc:hive2://<your-virtual-warehouse>.<your-environment>.<dwx.company.com>/default;transportMode=http;httpPath=cliservice;ssl=true;retries=3
  7. From the text file where you just pasted the URL, copy the host name from the JDBC URL to your system's clipboard. For example, in the URL shown in Step 6, the host name is: 
    <your-virtual-warehouse>.<your-environment>.<dwx.company.com>
  8. Start Tableau and navigate to Connect > More… > Cloudera Hadoop:


    This launches the Cloudera Hadoop dialog box.

  9. In the Tableau Cloudera Hadoop dialog box, paste the host name you copied to your clipboard in Step 7 into the Server field:


  10. Then in the Tableau Cloudera Hadoop dialog box, set the following other options:
    • Port: 443
    • Type: HiveServer2
    • Authentication: Username and Password
    • Transport: HTTP
    • Username: Username you use to connect to the CDP Data Warehouse service.
    • Password: Password you use to connect to the CDP Data Warehouse service.
    • HTTP Path: cliservice
    • Require SSL: Make sure this is checked.
  11. Click Sign In.