KNOWLEDGE BASE

Error Message: "code '10002' 'Error while compiling statement: Failed: SemanticException" Connecting to Hadoop Hive


Published: 09 Feb 2015
Last Modified Date: 05 Aug 2015

Issue

When you try to connect to Hortonworks Hadoop Hive, the following error might occur:

[Hortonworks][Hardy] (35) Error from Hive: error code: '10002' error message: 'Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 2:13 Invalid column reference '<column_name>'''. 

 

Environment

  • Tableau Desktop 8.2
  • Hortonworks Hadoop Hive

Resolution

Ensure that you are using the current drivers for Hortonworks Hadoop Hive. For more information, see Drivers & Activation.

Cause

Some older Hortonworks drivers are incompatible with newer versions of Hortonworks Hadoop Hive.
Did this article resolve the issue?