KNOWLEDGE BASE

Error "SemanticException [Error 10002]: Line 1:25 Invalid column reference" When Connecting to Hortonworks


Published: 05 Aug 2014
Last Modified Date: 10 Jan 2017

Issue

When connecting to Hortonworks, the following error might occur:
 
[Hortonworks][HiveODBC] (35) Error from Hive: error code: '10002' error message: 'Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 1:25 Invalid column reference 'fieldname''

Environment

  • Tableau Desktop
  • Hortonworks Hadoop Hive

Resolution

Uninstall all Hortonworks drivers currently installed on the computer running Tableau Desktop.
Install the recommended drivers as described at Driver Download.

Cause

Incompatible Hortonworks driver installed. 
Did this article resolve the issue?