How many users have logged-in to the Hadoop system (or accessed the HIVE database) since the beginning, broken down by months.

Question

We are planning to upgrade from HDP to CDP version.
How many users have logged-in to the Hadoop system (or accessed the HIVE database) since the beginning, broken down by months.
We need to report for this Hadoop system for better utilization and performance.
we are using Amabari HDP 2.6.5 version.

Could you please help me on this issue.

ChethanYM · Accepted Answer

Hi @Ramesh_hdp

I do not think we have an option to check number of users are logged into Hive, But we can check how many connections are made to Hive.

>you can refer the below article:

https://community.cloudera.com/t5/Support-Questions/How-to-get-number-of-live-connections-with-HiveServer2-HDP-2/td-p/106284

>If you enable Hiveserver2 UI then under Active Sessions you can see which user connected from which IP

Regards,

Chethan YM

Ramesh_hdp · Answer

@Former Member --Thanks for sharing information.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.