Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Rich Talbot
  • Updated
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