Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIve Table - Setup Retention

HIve Table - Setup Retention

New Contributor

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
Highlighted

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

New Contributor

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"