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)
