Support Questions
Find answers, ask questions, and share your expertise

HIve Table - Setup Retention

HIve Table - Setup Retention

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

3 REPLIES 3

Re: HIve Table - Setup Retention

Super Collaborator

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

Re: HIve Table - Setup Retention

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?

Re: HIve Table - Setup Retention

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"