Skip to main content

Loading data Hadoop Hive returns "Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'"

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

Loading data Hadoop Hive returns "Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'"


Solution:

When connecting to Hadoop Hive table or joining multiple hive tables, the data does not load in Spotfire and the following error message might occur: 

ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'


  This issue is caused by the HiveServer2 failing to execute a MapReduce Local Task and it does not seem bound to queries submitted through ODBC. To resolve, work with your Hadoop administrator to ensure that provided user has permissions to access the table and join multiple tables. External: Cloudera ODBC Driver - Error when joining tables 

Comments

0 comments

Article is closed for comments.