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.
   • On Manager, bind the current user to a role with the corresponding permission, for example, default. For details, see Modifying User Information.
   • If Ranger authentication is enabled for Hive, you can configure the permission for the current user to submit jobs in the specified Yarn queue by referring to Adding a Ranger Access Permission Policy for Yarn.

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