Support Questions

Find answers, ask questions, and share your expertise

HIve Table - Setup Retention


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)?


Super Collaborator

Hi @Kashif Amir,

what is the HDP version you are using ?

if the version is HDP 2.X please see

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?

Super Collaborator

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"