Community Articles

Find and share helpful community-sourced technical articles.
Labels (2)
Cloudera Employee

PROBLEM: Unable to run insert query from Ambari Hive View with Kerberos enabled.

Error: Error in /var/log/ambari-server/hive-next-view/hive-view.log

Caused by: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from
	at org.apache.hive.jdbc.HiveStatement.waitForOperationToComplete(
	at org.apache.hive.jdbc.HiveStatement.execute(
	at org.apache.ambari.view.hive2.HiveJdbcConnectionDelegate.execute(

Corresponding Error in RM UI Application_xxxx_xxx Diagnostics:

Application application_1494540056219_0008 failed 2 times due to AM Container for
appattempt_1494540056219_0008_000002 exited with exitCode: -1000
For more detailed output, check the application tracking page: Then click on links to logs of each attempt.
Diagnostics: Application application_1494540056219_0008 initialization failed (exitCode=255) with output: main :
command provided 0
main : run as user is admin
main : requested yarn user is admin
User admin not foundFailing this attempt.
Failing the application.

ROOT CAUSE: Since Kerberos is enabled and "hive.server2.enable.doAs" property in Hive is true which is "Run as end user instead of Hive user is true", it looks for end user to be present locally in every Node Managers.

SOLUTION: Create end user running the hive queries locally or have it present via AD/LDAP.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎06-30-2017 04:19 AM
Updated by:
Top Kudoed Authors