Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-28168

new command to implement kill session on HS2

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Hive, HiveServer2
    • None

    Description

      As part of 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.

      # MYSQL 

KILL [CONNECTION | QUERY] process_id;

# ORACLE

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

      Ref -

      https://dev.mysql.com/doc/refman/8.0/en/kill.html
      https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/283689.htm

      Attachments

        Issue Links

          is a parent of

          New Feature - A new feature of the product, which has yet to be developed. HIVE-27829 New command to display current connections on HS2 and HMS instances

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              Gangadharan Gopinath
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: