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.

Best way to find who created a table

Highlighted

Best way to find who created a table

Explorer

Hi,

 

I want to find who created a bunch of tables so I can contact them.  Is navigator the best way to do this ?

 

If you search the audits in Navigator It seems that in HIVE the operation is CREATETABLE and in Impala it is CREATE_TABLE which makes it awkward.  Also if we are only retaining 3 months of data in Navigator then is there an option to find the creator of a table older than 3 months ?

 

Thanks