[
https://issues.apache.org/jira/browse/IMPALA-12648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17891679#comment-17891679
]
Fang-Yu Rao commented on IMPALA-12648:
--------------------------------------
Regarding the authorization of the KILL QUERY statement, based on the
description in RANGER-1851, a new type of resource "*Hive Service*" was
introduced on which a new type of action "*Service Admin*" could be applied in
order for Ranger to tell whether the requesting user is an administrator.
Refer to !ranger_policy_hiveservice_7.3.0.0-128_screenshot.png|thumbnail! for
an example of such a Ranger policy.
Currently Impala supports neither this new type of resource nor the new type of
action.
To reduce the complexity of this patch, to determine whether the requesting
user is an administrative user, for now it may be a good idea to register the
ALL privilege (action) on SERVER (resource) during the query analysis. We could
create a follow-up JIRA to keep track of aligning Apache Impala with Apache
Hive with respect to the required privilege to execute the KILL QUERY statement.
> Support killing queries and sessions programatically
> ----------------------------------------------------
>
> Key: IMPALA-12648
> URL: https://issues.apache.org/jira/browse/IMPALA-12648
> Project: IMPALA
> Issue Type: New Feature
> Components: Frontend
> Affects Versions: Impala 4.3.0
> Reporter: Manish Maheshwari
> Assignee: Xuebin Su
> Priority: Major
> Attachments: ranger_policy_hiveservice_7.3.0.0-128_screenshot.png
>
>
> Support killing queries and sessions programatically via kill commands to be
> able to manage impala running workloads.
> 1. Killing Queries that are currently running
> {code:java}
> -- Forcibly terminates query with the specified query_id:
> KILL QUERY WHERE query_id='634bf9fcf55278eb:ac0ef05300000000' {code}
> For queries that are the finished and waiting to be closed, this command
> should close them
> 2. Killing sessions that are open
> {code:java}
> -- Forcibly terminates session and closes all queries:
> KILL SESSION WHERE session_id='2644d52c79c4c1e4:e974538f2189ed82' {code}
> this command should terminate the session and kill all active queries and
> close all queries that are finished and are waiting to be closed.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
