KNOWLEDGE BASE

Error "ExecuteStatement finished with operation state: ERROR_STATE" When Adding Fields to View


Published: 20 Jul 2015
Last Modified Date: 21 Jul 2016

Issue

When adding fields to a view that has a live connection to a Hadoop Hive data source, the following error might occur:

ExecuteStatement finished with operation state: ERROR_STATE

Environment

  • Tableau Desktop
  • Hortonworks Hadoop Hive

Resolution

Work with Hortonworks support to ensure that the Hadoop user's home directory has been created correctly.

Cause

The HDFS user's home directory may have been created in a way that Hadoop can not recognize. When MapReduce is triggered, a required .jar file cannot be written to the directory.

Additional Information

The following error message might appear in the Hortonworks Hadoop log files:
 
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=<>, access=WRITE, inode="/user":<>
Did this article resolve the issue?