question Re: Is it possible to not log about OPEN event in Navigator please? in Archives of Support Questions (Read Only)

Is it possible to not log about OPEN event in Navigator please?

kangkang0705 — Mon, 02 Oct 2017 11:27:46 GMT

Dear sir / madam,

Our cloudera versiion is 5.7.2 with Navigator and the metadata database is Postgresql. We are facing a problem about the metadata database goes full very quickly. I did query the metadata database and found that the event about OPEN got more than 48,542,073 records per day. (select ip_addr, operation, count(*) as C from hdfs_audit_events_2017_10_02 group by ip_addr, operation order by C;). Therefore is there any way to not log about OPEN event in Navigator please?

(Here the OPEN event is about open file, NOT open connection; there are the other events such as "create", "rename", "delete" and more)

Your faithfully,
Chao-Kang Chen

Re: Is it possible to not log about OPEN event in Navigator please?

zherczeg — Mon, 02 Oct 2017 15:14:03 GMT

Hello kangkang0705,

You can achieve that via setting up rules for "Audit Event Filter" according to Configuring Service Auditing Properties. Please note that the audit events discarded this way will never reach the Cloudera Navigator database, because of that you'll have no way to review them in the future.

Let me know if that helps.

Best regards,
Zsolt

Re: Is it possible to not log about OPEN event in Navigator please?

kangkang0705 — Mon, 02 Oct 2017 17:55:12 GMT

Dear zherczeg

Thank you so much for your kind help! I believe your method will work perfectly. I will implement it tomorrow and report to you the result within this week due to that the admin team might want to observe several days.

Your sincerely,

Chao-Kang Chen