Loading

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

Publiseringsdato: Apr 13, 2024
Beskrivelse
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. 
Løsning
Use Initial SQL to connect to the data source and set a server-side variable using the following code: 

SET hive.mapred.mode = ‘nonstrict’

Flere ressurser
Run Initial SQL
Knowledge-artikkelnummer

001473243

 
Laster
Salesforce Help | Article