https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106286#M33498 <P>Thanks <A rel="user" href="https://community.cloudera.com/users/8919/rajkumarsingh.html" nodeid="8919">@Rajkumar Singh</A> thats works ... probably a wrong question from my end ... but was looking for live "sessions" on HS2 and if possible users</P> Thu, 30 Jun 2016 19:23:58 GMT nyakkanti 2016-06-30T19:23:58Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106284#M33496 <P>HiveServer2 hangs silently, need to check how many live connections are on HS2, how can this be done ? </P> Thu, 30 Jun 2016 19:10:19 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106284#M33496 nyakkanti 2016-06-30T19:10:19Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106285#M33497 <P>on the host where hs2 is running do</P><P>lsof -i:10000|grep 'ESTABLISHED'|wc -l</P> Thu, 30 Jun 2016 19:14:51 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106285#M33497 rajkumar_singh 2016-06-30T19:14:51Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106286#M33498 <P>Thanks <A rel="user" href="https://community.cloudera.com/users/8919/rajkumarsingh.html" nodeid="8919">@Rajkumar Singh</A> thats works ... probably a wrong question from my end ... but was looking for live "sessions" on HS2 and if possible users</P> Thu, 30 Jun 2016 19:23:58 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106286#M33498 nyakkanti 2016-06-30T19:23:58Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106287#M33499 <A rel="user" href="https://community.cloudera.com/users/346/nyakkanti.html" nodeid="346">@nyakkanti</A><P>I think there is no direct way to do this but you can try to grep some log text.</P><P>or </P><P>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.</P> Thu, 30 Jun 2016 19:32:39 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106287#M33499 rajkumar_singh 2016-06-30T19:32:39Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106288#M33500 <P>By connecting to web ui over port 10002 one could check the number of live sessions on that instance of hiveserver</P> Wed, 10 Jan 2018 07:44:35 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/m-p/106288#M33500 asreekumar 2018-01-10T07:44:35Z