[ https://issues.apache.org/jira/browse/HIVE-27829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Riju Trivedi reassigned HIVE-27829: ----------------------------------- Assignee: Riju Trivedi > 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 > Assignee: Riju Trivedi > Priority: Major > > 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. > > We can even extend this command to show connections between an HMS instance > and backend database to troubleshoot issues between HMS and backend database -- This message was sent by Atlassian Jira (v8.20.10#820010)