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 tell what HIVE table partitions have been archived

How to tell what HIVE table partitions have been archived

Explorer

If I run the 'ALTER TABLE blah ARCHIVE partition blah' how can I then later determine what partitions have been archived ?

 

I am asking this question because I want to code a script that archives old partitions that have not yet been archived.

 

It would be great if the answer was something like 'look in the hive metastore using query xxx' rather than 'inspect each partition folder and determine if it has any .har files in it'

 

Thanks

 

Don't have an account?
Coming from Hortonworks? Activate your account here