question Re: Need an easy and performant way to purge data older than 24 months from Hbase Tables in Support Questions https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212097#M174036 <P><A rel="user" href="https://community.cloudera.com/users/372/enis.html" nodeid="372">@Enis</A> </P><P>Thanks for the quick response.</P><P>After setting TTL in table we have to run the Major to delete older-than-TTL-time data right?</P><P>How to do this.</P> Sat, 05 Aug 2017 01:39:53 GMT nshelke 2017-08-05T01:39:53Z Need an easy and performant way to purge data older than 24 months from Hbase Tables https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212095#M174034 Sat, 05 Aug 2017 00:39:08 GMT https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212095#M174034 nshelke 2017-08-05T00:39:08Z Re: Need an easy and performant way to purge data older than 24 months from Hbase Tables https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212096#M174035 <P>You can use Time To Live (TTL) attribute for the table for this. You can read about it here <A href="https://hbase.apache.org/book.html#ttl" target="_blank">https://hbase.apache.org/book.html#ttl</A></P> Sat, 05 Aug 2017 01:13:46 GMT https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212096#M174035 Enis 2017-08-05T01:13:46Z Re: Need an easy and performant way to purge data older than 24 months from Hbase Tables https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212097#M174036 <P><A rel="user" href="https://community.cloudera.com/users/372/enis.html" nodeid="372">@Enis</A> </P><P>Thanks for the quick response.</P><P>After setting TTL in table we have to run the Major to delete older-than-TTL-time data right?</P><P>How to do this.</P> Sat, 05 Aug 2017 01:39:53 GMT https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212097#M174036 nshelke 2017-08-05T01:39:53Z Re: Need an easy and performant way to purge data older than 24 months from Hbase Tables https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212098#M174037 <P>you can use "major_compact" command to run a major compaction on the table.</P><P>In HBase shell:-</P><PRE><CODE>hbase(main):013:0&gt; major_compact 'tablename'</CODE></PRE> Mon, 07 Aug 2017 13:22:29 GMT https://community.cloudera.com/t5/Support-Questions/Need-an-easy-and-performant-way-to-purge-data-older-than-24/m-p/212098#M174037 asinghal 2017-08-07T13:22:29Z