Support Questions
Find answers, ask questions, and share your expertise

Best way to find who created a table




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 ?