question Re: How many users connected to HiveServer2 in Support Questions

How many users connected to HiveServer2

Nil_kharat — Tue, 21 Apr 2026 08:59:50 GMT

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 ?

Shifu — Wed, 11 Aug 2021 05:33:58 GMT

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

Nil_kharat — Fri, 13 Aug 2021 15:02:14 GMT

Thank you so much @Shifu

can we have these command also

lsof -i:10000 | grep 'ESTABLISHED' | wc -l

Shifu — Sun, 15 Aug 2021 02:41:16 GMT

Yes, you can also use the particular lsof command as well to figure out the number of established connections to the particular port.