Need an easy and performant way to purge data older than 24 months from Hbase Tables

[#1 · Accepted solution]

You can use Time To Live (TTL) attribute for the table for this. You can read about it here https://hbase.apache.org/book.html#ttl

[#2]

@Enis

Thanks for the quick response.

After setting TTL in table we have to run the Major to delete older-than-TTL-time data right?

How to do this.

[#3]

you can use "major_compact" command to run a major compaction on the table.

In HBase shell:-

hbase(main):013:0> major_compact 'tablename'