KNOWLEDGE BASE

Error "[Cloudera][HiveODBC](80) Syntax or sematic analysis error thrown in Hive while executing query." Connecting To Cloudera Hadoop


Published: 27 Aug 2015
Last Modified Date: 11 Aug 2017

Issue

When you try to connect to Cloudera Hadoop Hive, the following error occurs:
 
[Cloudera][HiveODBC](80) Syntax or sematic analysis error thrown in Hive while executing query. Error message from Hive: Error while compiling statement: FAILED: SemanticException [Error10041]: No partition predicate found for Alias "<Table Name>" Table "<Table Name>"

Environment

  • Tableau Desktop 
  • Cloudera Hadoop Hive 

Resolution

Use Initial SQL to connect to the data source and set a server-side variable using the following code: 

SET hive.mapred.mode = ‘nonstrict’

Cause

In strict mode, the database requires the connection to specify a static partition rather than connecting to dynamic partitions. 
Did this article resolve the issue?