Menu
    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: 23 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?    
    PRINT THIS PAGE
    Related Links
    Initial SQL
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE