Support Questions
Find answers, ask questions, and share your expertise

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

Expert Contributor

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


on the host where hs2 is running do

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

View solution in original post


on the host where hs2 is running do

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

Expert Contributor

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


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


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.


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

; ;