How to get number of live connections with HiveServer2 (HDP 2.2.4)

[#1]

HiveServer2 hangs silently, need to check how many live connections are on HS2, how can this be done ?

[#2 · Accepted solution]

on the host where hs2 is running do

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

[#3]

Thanks @Rajkumar Singh thats works ... probably a wrong question from my end ... but was looking for live "sessions" on HS2 and if possible users

[#4]

@nyakkanti

I think there is no direct way to do this but you can try to grep some log text.

or

take a heap dump of hiveserver2 and use object query language ( SELECT toString(s.username) FROM INSTANCEOF org.apache.hive.service.cli.session.HiveSessionImpl s ) to know live sessions at that moment. to run object query language you can use jvisualvm or Eclipse MAT.

[#5]

By connecting to web ui over port 10002 one could check the number of live sessions on that instance of hiveserver