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

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

Ramesh_hdp — Wed, 07 Sep 2022 10:49:23 GMT

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.

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

ChethanYM — Wed, 07 Sep 2022 14:18:15 GMT

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

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

Ramesh_hdp — Wed, 07 Sep 2022 15:04:14 GMT

@chethan --Thanks for sharing information.