Connect Tableau to HiveServer2

Instructions for connecting to the Hive Thrift server via Tableau

  • Ensure that LDAP authentication for Tableau to HiveServer2 is enabled. For more information, refer to section 'Enable LDAP for Connecting Tableau to HiverServer2 of the 'Urika®-GX System Administration Guide'.
  • This procedure requires the following software to be installed on the client machine (which is an external machine connected to Urika-GX):
    • Tableau Desktop (version 10.0.1.0)
    • Hortonworks Hive ODBC driver.
  • If using a Mac, the following procedure requires version 10.10 of the OS X operating system.
  • Request an administrator to ensure that the Hive service is up and running.
CAUTION: It is recommended for multiple users to use the same Hive server (that has been started by an administrator) instead of spinning up their own individual servers, as doing so could result in resource lockdown.
  1. Log on to a Urika-GX system's login node.
  2. Request an administrator to flex up the YARN cluster.
    Note: Cray recommends that YARN clusters for Tableau connectivity be flexed up only by administrators on Urika-GX. Administrators should use the urika-yam-flexup command and specify a timeout value of 0 when using this procedure. For more information, administrators should see the urika-yam-flexup man page or refer to the section titled 'Flex up a YARN sub-cluster on Urika-GX' of the 'Urika®-GX Analytic Applications Guide'.
  3. Launch the Tableau application on a client machine.
    This will start the Tableau application and bring up the Tableau UI on the user's desktop.
    Figure: Tableau UI
  4. Navigate to Connect > To a Server > More
  5. Select Hortonworks Hadoop Hive from the list of servers.
    Figure: Selecting Hortonworks Hadoop Hive Server
  6. Populate the server connection pop up.
    1. Enter hostname-login1 in the Server field, where hostname is used as an example for the name of the machine and should be replaced with the actual machine name when following this step.
    2. Enter 10000 in the Port field.
    3. Select HiveServer2 from the Type drop down.
    4. Select User Name and Password from the Authentication drop down.
    5. Enter values in the Username and Password fields.
    6. Select the Sign In button.
      Figure: Connect HiveServer2 to Tableau
  7. Perform data visualization/exploration tasks as needed using Tableau.
  8. Request an administrator to flex down the YARN cluster.
    Note: Cray recommends that YARN clusters for Tableau connectivity be flexed down only by administrators on Urika-GX. For more information, administrators should see the urika-yam-flexdown man page or refer to the section titled 'Flex up a YARN sub-cluster on Urika-GX' of the 'Urika®-GX Analytic Applications Guide'.