How to set the partition life cycle of the hive table？

[#1]

How to set the partition life cycle of the hive table？

Error: Error while compiling statement: FAILED: ParseException line 1:270 missing EOF at 'lifecycle' near ')' (state=42000,code=40000)

[#2 · Accepted solution]

Hi, Do you mean partition retention time for Hive tables? If yes please refer the below documentation.

https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/using-hiveql/content/hive-set-partition-retent...

The above error you are seeing looks like a syntax error with in your query.

Regards,

Chethan YM

[#3]

Thank you for helping me solve the problem。