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

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Hive, HiveServer2, Standalone Metastore
• Labels: pull-request-available
• Assignee: Riju Trivedi
• Reporter: Taraka Rama Rao Lethavadla
• Created: 30/Oct/23 09:07
• Updated: 09/Sep/24 10:27

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

Issue Links

• is a child of: HIVE-28168 new command to implement kill session on HS2
• links to: GitHub Pull Request #5319