Reply
New Contributor
Posts: 1
Registered: ‎03-07-2019
Accepted Solution

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

[ Edited ]

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.

Expert Contributor
Posts: 92
Registered: ‎01-08-2016

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

Hello @Damat,

 

You can use Service Audit Event Fields

 

Hope that helps

Highlighted
Cloudera Employee
Posts: 232
Registered: ‎01-15-2015

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

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.