Loading

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

Data pubblicazione: Apr 13, 2024
Descrizione
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. 
Risoluzione
Use Initial SQL to connect to the data source and set a server-side variable using the following code: 

SET hive.mapred.mode = ‘nonstrict’

Risorse aggiuntive
Run Initial SQL
Numero articolo Knowledge

001473243

 
Caricamento
Salesforce Help | Article