HIve Table - Setup Retention

[#1]

Hi,

Is there a way to

1) Setup table retention in a Hive table properties? AND/ OR

2) Automate the process of applying retention policy on Hive partitioned tables (partition based on date)?

[#2]

Hi @Kashif Amir,

what is the HDP version you are using ?

if the version is HDP 2.X please see https://falcon.apache.org/FalconDocumentation.html#Retention

[#3]

Hi @subhash parise,

Thank you for your insight.

The HDP version is 2.6.4.

I haven't setup Falcon in the environment. Any other possible way to achieve the same?

[#4]

Hi @Kashif Amir,

The other way is automate this task by using shell or python:

you can get the table creation by using "desc formatted db.tablename"