You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Gopinath (Jira)" <ji...@apache.org> on 2024/04/01 05:59:00 UTC

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

Gopinath created HIVE-28168:
-------------------------------

             Summary: 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


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)