question Re: How to monitoring IP list accessing hive (or using hive query)? in Support Questions

How to monitoring IP list accessing hive (or using hive query)?

Damat — Fri, 16 Sep 2022 14:13:30 GMT

I am managing CDH 5.6.0 consisting of 16 Linux servers. (1 eco, 2 namenodes, 13 datanodes)

The Cloudera Hadoop has no trouble issue, but nowadays, the rate of analyzing process was increased. Anyone associated with analyzing can access CDH hive by using SQL communication program(ex, dbeaver). What concerns me is termination of the CDH cluster, because, they send so many queries to the hive.

Is there the way monitoring client IP accessing to hive?

Thank you.

Re: How to monitoring IP list accessing hive (or using hive query)?

Consult — Tue, 12 Mar 2019 06:13:31 GMT

Hello @Damat,

You can use Service Audit Event Fields

Hope that helps

Re: How to monitoring IP list accessing hive (or using hive query)?

gzigldrum — Tue, 12 Mar 2019 15:04:50 GMT

As @Consult mentioned, you can use the Cloudera Navigator UI to query for Hive audit events, in the Audits tab. Each audit event is associated with the username and the IP address of the client request. This should help you to get an idea of who runs the most queries.