[jira] [Commented] (HIVE-28168) new command to implement kill session on HS2

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

    [ 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)