[
https://issues.apache.org/jira/browse/HIVE-28168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Riju Trivedi reassigned HIVE-28168:
-----------------------------------
Assignee: Riju Trivedi
> new command to implement kill session on HS2
> --------------------------------------------
>
> Key: HIVE-28168
> URL: https://issues.apache.org/jira/browse/HIVE-28168
> Project: Hive
> Issue Type: Improvement
> Components: Hive, HiveServer2
> Reporter: Gopinath
> Assignee: Riju Trivedi
> Priority: Major
>
> As part of [HIVE-27829|https://issues.apache.org/jira/browse/HIVE-27829] , we
> have planned to implement the 'show sessions' feature.
> Given that MySQL supports 'kill connection' and Oracle supports 'kill
> session', implementing 'kill session' functionality is also valid for Hive.
> This command aids in freeing up memory within the Hive service.
> {noformat}
> # MYSQL
> KILL [CONNECTION | QUERY] process_id;
> # ORACLE
> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;
> {noformat}
> Ref -
> https://dev.mysql.com/doc/refman/8.0/en/kill.html
> https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/283689.htm
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
