Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution

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

New Contributor

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions

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

Expert Contributor

Hello @Damat,

 

You can use Service Audit Event Fields

 

Hope that helps

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

Expert Contributor

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.

2 REPLIES 2

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

Expert Contributor

Hello @Damat,

 

You can use Service Audit Event Fields

 

Hope that helps

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

Expert Contributor

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.