KNOWLEDGE BASE

Error "Error from Hive: error code: '40000' error message: "Error while processing statement: FAILED" Refreshing Extract


Published: 01 Jul 2014
Last Modified Date: 16 Jan 2017

Issue

When refreshing an extract on for Hortonworks HiveServer 2, the following error might occur:

[Hortonworks][HiveODBC] (35) Error from Hive: error code: '40000' error message: "Error while processing statement: FAILED: HiveException org.apache.hadoop.security.AccessControlException: Permission denied: user=<kerberos principal>, access=EXECUTE,
 
However, when using the Test Connection function in the Edit Data Connection dialog on Tableau Server, the connection succeeds.

Environment

  • Tableau Server
  • Hortonworks Hadoop Hive

Resolution

Ensure the Kerberos principal has permissions to read the tables in the Hive cluster. The Test Connection dialog only checks for the ability to connect to the database, not run queries against the tables.

Cause

The Kerberos principal does not have permission to read the tables in the Hive cluster.
Did this article resolve the issue?