[
https://issues.apache.org/jira/browse/HIVE-27829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17916192#comment-17916192
]
Stamatis Zampetakis commented on HIVE-27829:
--------------------------------------------
Since this is a new feature we should add some documentation in the website.
Can someone please create a PR on [https://github.com/apache/hive-site] and
link it to this ticket.
> 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
> Labels: pull-request-available
> Fix For: 4.1.0
>
>
> 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)
