[
https://issues.apache.org/jira/browse/HIVE-28168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18032043#comment-18032043
]
Stamatis Zampetakis commented on HIVE-28168:
--------------------------------------------
This functionality is definitely useful however implementation wise it can only
work if we are able to close a session of another (Thrift) connection
gracefully that is quite tricky at the moment for the reasons explained under
(HIVE-11402, HIVE-14227, HIVE-29286). Sharing sessions across connections does
not play very well since session objects are not thread safe. If this is ever
implemented please ensure that you do lots of concurrency testing.
> 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)
