NoSQL: Cassandra Automatic Data Expiration using Time to Live (ttl)

Cassandra Automatic Data Expiration:

The Automatic Data Expiration is one of the feature of NoSQL Cassandra Database.
You can set expiration time in second to expire a particular data.
You can set Time to Live (ttl) value in seconds to set an expiration time.

The defined TTL data are marked with a Tombstone Garbage collector parameter (deletion marker) and after that data automatically removed during the compaction process.

You can change TTL value by re-insert the data with new TTL value.
The actual insertion is kind of INSERT or UPDATE because it checks the previous data version and accordingly it performs the action.
You can set the TTL value in both INSERT and UPDATE statements.

Automation Expiration of The Data, real time application use like, any e-commerce product is declaring different offers on products and each offer should expire after some time intervals.
In this kind of application, we can use the feature like the automation expiration of the Cassandra.

Small demonstration:

Create a sample table:

Insert one row using TTL for 20 second:
After 20 second, data automatically will be removed.

The Result:

NoSQL Cassandra Time To Live TTL

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

Be the First to Comment!

Notify of