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 track delete queries performed in HIVE ?

how to track delete queries performed in HIVE ?

Contributor

how to audit / track all delete queries executed in HIVE ?

4 REPLIES 4

Re: how to track delete queries performed in HIVE ?

Rising Star

Ranger Audit tracks all Hive operations (also allows "REVOKE DELETE" for users).

http://hortonworks.com/hadoop-tutorial/manage-security-policy-hive-hbase-knox-ranger/

Re: how to track delete queries performed in HIVE ?

Contributor

@gopal , any inernal parameter / setting in hive if we are not using ranger here...

Highlighted

Re: how to track delete queries performed in HIVE ?

Rising Star

No, you need to write code to do this.

hive.exec.pre.hooks allows you to hook into every command and log it/deny it.

Re: how to track delete queries performed in HIVE ?

Contributor

@gopal, thanks will check that