Reply
Highlighted
Explorer
Posts: 15
Registered: ‎05-03-2017

Best way to find who created a table

[ Edited ]

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

Announcements
New solutions