title: Hive Table retention support
body: <p>I want to support retention on a Hive table for old partitions. Basically I need to automatically delete Hive partitions after a specific period. I can manually do this or with a script but I have noticed that a retention property exists in every Hive Table but I can't find many information about it. </p>
  
  <p>For example when using descibe in a hive table there is a retention property </p>
  
  <pre><code>desc formatted my_hive_table;
  &gt;&gt;&gt;
  col_name                data_type                comment
  ...
  Retention:              0                        NULL
  ...
  </code></pre>
  
  <p>and I have found this 2014 <a href="https://issues.apache.org/jira/browse/HIVE-7025" rel="nofollow noreferrer">Jira</a> but I am not sure if it is implemented and how. </p>
  
  <p>Can anyone confirm if Hive supports this capability and if yes how to configure it properly?</p>