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

Posted to issues@hive.apache.org by "Taraka Rama Rao Lethavadla (Jira)" <ji...@apache.org> on 2023/10/30 09:08:00 UTC

[jira] [Created] (HIVE-27829) New command to display current connections on HS2 and HMS instances

Taraka Rama Rao Lethavadla created HIVE-27829:
-------------------------------------------------

             Summary: New command to display current connections on HS2 and HMS instances
                 Key: HIVE-27829
                 URL: https://issues.apache.org/jira/browse/HIVE-27829
             Project: Hive
          Issue Type: New Feature
          Components: Hive, HiveServer2, Standalone Metastore
            Reporter: Taraka Rama Rao Lethavadla


We would need a command to list current connections to HS2/HMS instances

It could like {*}show processlist{*}(Mysql) or {*}select * from pg_stat_activity{*}(Postgresql) or {*}show compactions{*}(Hive) to see current connections to the Hive Server2/HMS instances

This command can help in troubleshooting issues with Hive service. One can know the load on a given HS2/HMS instance with this command and identify inappropriate connections to terminate them



--
This message was sent by Atlassian Jira
(v8.20.10#820010)