title: Hive tables archive
body: <p>I want to apply archive and purge mechanism on hive tables, which includes internal and external tables and both partitioned and non-partitioned.</p>
  
  <p>I have a site_visitors table and its partitioned with visit_date.
  And I wanted to archive the site_visitors table data, where in users not visited my site in last one year. At the same time, I don't want to keep this archived data in same table directory. I can have archived data some specific location.</p>