Skip to main content
learningBody
Silver ⭐️
Feb 13, 2023 9:23 AM UTC
Solved

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

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)

ChethanYM
ChethanYMAnswer
Gold ⭐️
Feb 17, 2023 5:29 AM UTC

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-retention.html

 

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

 

Regards,

Chethan YM

2 replies

ChethanYM
Gold ⭐️
ChethanYMAnswer
Gold ⭐️
Feb 17, 2023 5:29 AM UTC

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-retention.html

 

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

 

Regards,

Chethan YM

Translate
learningBody
Silver ⭐️
Feb 24, 2023 6:12 AM UTC

Thank you for helping me solve the problem。

Translate