question Re: How to set the partition life cycle of the hive table？ in Support Questions https://community.cloudera.com/t5/Support-Questions/How-to-set-the-partition-life-cycle-of-the-hive-table/m-p/364042#M239098 <P>Hi, Do you mean partition retention time for Hive tables? If yes please refer the below documentation.</P><P><A href="https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/using-hiveql/content/hive-set-partition-retention.html" target="_blank">https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/using-hiveql/content/hive-set-partition-retention.html</A></P><P>&nbsp;</P><P>The above error you are seeing looks like a syntax error with in your query.</P><P>&nbsp;</P><P>Regards,</P><P>Chethan YM</P> Fri, 17 Feb 2023 05:29:18 GMT ChethanYM 2023-02-17T05:29:18Z How to set the partition life cycle of the hive table？ https://community.cloudera.com/t5/Support-Questions/How-to-set-the-partition-life-cycle-of-the-hive-table/m-p/363666#M239048 <P>How to set the partition life cycle of the hive table？</P><P>&nbsp;</P><P>Error: Error while compiling statement: FAILED: ParseException line 1:270 missing EOF at 'lifecycle' near ')' (state=42000,code=40000)</P> Mon, 13 Feb 2023 09:23:03 GMT https://community.cloudera.com/t5/Support-Questions/How-to-set-the-partition-life-cycle-of-the-hive-table/m-p/363666#M239048 learningBody 2023-02-13T09:23:03Z Re: How to set the partition life cycle of the hive table？ https://community.cloudera.com/t5/Support-Questions/How-to-set-the-partition-life-cycle-of-the-hive-table/m-p/364042#M239098 <P>Hi, Do you mean partition retention time for Hive tables? If yes please refer the below documentation.</P><P><A href="https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/using-hiveql/content/hive-set-partition-retention.html" target="_blank">https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/using-hiveql/content/hive-set-partition-retention.html</A></P><P>&nbsp;</P><P>The above error you are seeing looks like a syntax error with in your query.</P><P>&nbsp;</P><P>Regards,</P><P>Chethan YM</P> Fri, 17 Feb 2023 05:29:18 GMT https://community.cloudera.com/t5/Support-Questions/How-to-set-the-partition-life-cycle-of-the-hive-table/m-p/364042#M239098 ChethanYM 2023-02-17T05:29:18Z Re: How to set the partition life cycle of the hive table？ https://community.cloudera.com/t5/Support-Questions/How-to-set-the-partition-life-cycle-of-the-hive-table/m-p/364501#M239183 <P>Thank you for helping me solve the problem。</P> Fri, 24 Feb 2023 06:12:54 GMT https://community.cloudera.com/t5/Support-Questions/How-to-set-the-partition-life-cycle-of-the-hive-table/m-p/364501#M239183 learningBody 2023-02-24T06:12:54Z