KNOWLEDGE BASE

Unable to Configure Tableau Desktop to use TEZ Hive Execution Engine


Published: 18 Jan 2018
Last Modified Date: 23 Jan 2019

Issue

When connecting to Hortonworks Hadoop Hive, it is not possible to specify the TEZ execution engine. 
 

Environment

  • Tableau Desktop
  • Hortonworks Hadoop Hive

Resolution

  1. Use the Hortonworks Hadoop Hive ODBC Driver for Apache version 2.1.12 or later. It is possible to upgrade using the following link: https://hortonworks.com/downloads/
  2. When using the named connector for your Hive connection, add the following Initial SQL:
SET hive.execution.engine=tez

Cause

Earlier drivers for Hortonworks Hadoop Hive do not support the Initial SQL change of execution engine from the default MAPREDUCE to TEZ.
Did this article resolve the issue?