[
https://issues.apache.org/jira/browse/HIVE-27829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Taraka Rama Rao Lethavadla updated HIVE-27829:
----------------------------------------------
Description:
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
was:
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
> 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
> 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)
