Apache Hive | Tableau Exchange

Apache Hive

by Tableau

Description

The Apache Hive Connector is a powerful tool that allows you to connect with live data to open source Apache Hive analyze the data directly in Tableau Connector contains an embedded SQL Engine that pushes supported SQL operations to the data source and processes unsupported operations client-side (Query Folding):

  • Issue complex queries using SQL-92 compliant operations and clauses.
  • Leverage server-side data processing for supported operations.
  • Build new relationships and custom datasets.

Connector supports bulk operations, push-down, client functions, aggregation and advanced TLS/SSL data encryption.

Installation

  1. Download the Connector file (.taco).
  2. Move the .taco file here:
    • Windows: C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors
    • macOS: /Users/[user]/Documents/My Tableau Repository/Connectors
    • Server Windows: C:\Program Files\Tableau\Connectors
    • Server Linux: /opt/tableau/connectors
  3. Install the JDBC Driver
    • Go to the Driver Download link
    • Download the JDBC .jar file and move into the following directory:
      • Windows - C:\Program Files\Tableau\Drivers
      • macOS - /Users/[user]/Library/Tableau/Drivers
      • Linux: /opt/tableau/tableau_driver/jdbc
  4. Launch Tableau Desktop
  5. Go to ConnectTo a Server and select Apache Hive

Note: There are no licensing fees when you use the CData driver with the Apache Hive Tableau Connector. However, if you use the CData driver with the Tableau Other Databases (ODBC) connector or outside of Tableau, licensing fees will apply.

Tech Specifications

Version
25.9347.0
Works with
Tableau 2021.2 and later

Resources