Loading

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

Julkaisupäivä: Apr 13, 2024
Kuvaus
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>"

Cause

In strict mode, the database requires the connection to specify a static partition rather than connecting to dynamic partitions. 
Ratkaisu
Use Initial SQL to connect to the data source and set a server-side variable using the following code: 

SET hive.mapred.mode = ‘nonstrict’

Lisäresurssit
Run Initial SQL
Knowledge-artikkelin numero

001473243

 
Ladataan
Salesforce Help | Article