Help Center/ MapReduce Service/ Troubleshooting/ Using Hive/ Insufficient User Permission for Running the insert into Command on Hive
Updated on 2023-11-30 GMT+08:00

Insufficient User Permission for Running the insert into Command on Hive

Issue

When a user runs the insert into command on the Beeline CLI, the following error message is displayed:

INFO  : Concurrency mode is disabled, not creating a lock manager
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. org.apache.hadoop.yarn.exceptions.YarnException: Failed to submit application_xxx to YARN : User xxx cannot submit application application_xxx to queue root.default. ACL check failed. (state=08S01,code=1) 

Cause Analysis

The user who submits the job does not have the permission on the Yarn queue.

Procedure

  1. Configure the Yarn queue permission for the current user.

  2. After the permission configuration takes effect, run the command again.