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

[#1]

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.

[#2 · Accepted solution]

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-HiveS...

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

Regards,

Chethan YM

[#3]

@chethan --Thanks for sharing information.