KNOWLEDGE BASE

Error "Invalid Column Reference '#Partition Information'" When Connecting to Hortonworks Hadoop Hive


Published: 02 Feb 2016
Last Modified Date: 30 Dec 2016

Issue

When working with Hortonworks Hadoop Hive, you might encounter the following error:
[HiveODBC] (35) Error from Hive: error code: '10002' error message: 'Error while compiling statement:
FAILED: SemanticException [Error 10002]: Line 1:25 Invalid column reference '# Partition Information"

Environment

  • Tableau Desktop 
  • Hortonworks Hadoop Hive

Resolution

Update to the latest version of the Hortonworks driver or contact Hortonworks to obtain the latest version of the Hive driver.

Cause

This behavior was related to a known issue with the Hortonworks 2.0.0 driver.
Did this article resolve the issue?