Solved
How many users connected to HiveServer2
Hi Folks,
Can anyone tell me how to check how many users are connected to the hive server2?
And along with can we see which user is connected ?
ShifuAnswer
Gold ⭐️⭐️
August 11, 2021
Hi
Question: Can anyone tell me how to check how many users are connected to the hive server2?
Answer: Login to the server where hiveserver2 is running and run the below command to figure out the number of connections to the HS2
# netstat -ntpl | grep 10000
In the above command 10000 is the HS2 port number
You can also check this from Cloudera manager
CM > Hive_on_Tez > Instances > HiveServer2 > Open Connections
And along with can we see which user is connected?
If you enable Hiveserver2 UI then under Active Sessions you can see which user connected from which IP.
Please check the below link.
https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2#SettingUpHiveServer2-WebUIforHiveServer2
If you are happy with the answer, mark it Accept as solution
