question Re: How to kill Hive job with individual user ID when hive doas=false is set in HiveServer2 (hive impersonation) in Archives of Support Questions (Read Only)

How to kill Hive job with individual user ID when hive doas=false is set in HiveServer2 (hive impersonation)

ScipioTheElder — Tue, 17 May 2016 04:44:59 GMT

When a user submits a query via Beeline, HS2 in turn runs the query with user hive as doas is set to false.

How could a user kill the job? It should be a command via beeline to ask HS2 to kill on behalf of a user.

Snapshot:

XYZ $ yarn application -kill application_1461543063850_12340

16/05/16 11:56:13 INFO impl.TimelineClientImpl: Timeline service address: ...

16/05/16 11:56:13 INFO client.RMProxy: Connecting to ResourceManager at ...

Killing application application_1461543063850_12340

Exception in thread "main" org.apache.hadoop.yarn.exceptions.YarnException: java.security.AccessControlException: User XYZ cannot perform operation MODIFY_APP on application_1461543063850_12340

Re: How to kill Hive job with individual user ID when hive doas=false is set in HiveServer2 (hive impersonation)

tsaito — Tue, 17 May 2016 06:09:38 GMT

If you enable yarn.acl.enable, you can use an user defined by yarn.admin.acl to kill the application.

Re: How to kill Hive job with individual user ID when hive doas=false is set in HiveServer2 (hive impersonation)

ScipioTheElder — Wed, 18 May 2016 02:11:17 GMT

That should work. My original thought is to grant a user the ability to kill his own job. It is OK to promote him to the admin of the Yarn queue.

Re: How to kill Hive job with individual user ID when hive doas=false is set in HiveServer2 (hive impersonation)

bandarusridhar1 — Wed, 18 May 2016 07:33:05 GMT

@ScipioTheYounger

Only the Hive users can kill the job or the instance on which user job is running will have privileges to kill the job. If you want the By setting hive.server2.enable.doAs=true will give access to the user who running job can kill.