Prev Next

Database / Apache Cassandra Intermediate and Advanced interview questions

What are tombstones in Cassandra?

Because Cassandra's SSTables are immutable once written, it cannot simply erase a row or column in place. Instead, a delete writes a tombstone — a special marker recording that a value was deleted, along with a timestamp.

  • Tombstones can exist at the cell, row, range, or partition level, depending on what was deleted.
  • During reads, tombstones are merged in like any other value and suppress the deleted data so it does not appear in results.
  • Tombstones are only physically removed during compaction, and only after gc_grace_seconds has passed since the delete, giving the cluster time to replicate the delete everywhere via repair.
DELETE FROM orders WHERE order_id = 'abc123';
-- writes a tombstone, doesn't immediately free disk space

If a tombstone were removed too early — before every replica had seen it — a replica that missed the delete could later resurrect the old value during a read or repair. That's precisely why gc_grace_seconds exists as a safety window before permanent removal.

Why does Cassandra use tombstones instead of deleting data immediately?
When are tombstones physically purged from disk?

Invest now in Acorns!!! 🚀 Join Acorns and get your $5 bonus!
Acorns Logo

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Earn passively and while sleeping

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Robinhood Logo

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.


Webull Logo

Webull! Receive free stock by signing up using the link: Webull signup.

More Related questions...

What is the difference between a partition key and a clustering key? How does Cassandra achieve tunable consistency? What is the difference between consistency levels ONE, QUORUM, and ALL? Explain the write path in Cassandra? Explain the read path in Cassandra? What is the role of a coordinator node in Cassandra? What is the gossip protocol in Cassandra? How does Cassandra detect node failure? What are virtual nodes (vnodes) and why does Cassandra use them? What is consistent hashing and how does Cassandra use it? What is a partitioner in Cassandra? What is a snitch in Cassandra and what does it do? What is the difference between SimpleStrategy and NetworkTopologyStrategy? What is hinted handoff in Cassandra? What is read repair in Cassandra? What is the difference between hinted handoff and read repair? What is anti-entropy repair and why is it needed? What is the difference between full repair and incremental repair? What are tombstones in Cassandra? Why can excessive tombstones degrade Cassandra performance? What is gc_grace_seconds and why does it matter? What are the different compaction strategies available in Cassandra? When would you choose Leveled Compaction Strategy over Size-Tiered Compaction Strategy? What is Time Window Compaction Strategy used for? What are lightweight transactions (LWT) in Cassandra? Why are lightweight transactions expensive in Cassandra? What role does the Paxos protocol play in Cassandra's lightweight transactions? What are secondary indexes in Cassandra, and when should you avoid them? What is a materialized view in Cassandra? What is the difference between a secondary index and a materialized view? What is SASI (SSTable Attached Secondary Index) in Cassandra? What are User Defined Types (UDTs) in Cassandra? What are counter columns in Cassandra and what are their limitations? What is a wide partition in Cassandra and why is it a problem? How do you model time-series data in Cassandra? What is the ALLOW FILTERING clause and why is it risky? What is a batch statement in Cassandra, and what's the difference between logged and unlogged batches? Why shouldn't Cassandra batches be used to improve write throughput? What is Change Data Capture (CDC) in Cassandra? What is speculative retry in Cassandra? What is token awareness in Cassandra drivers? What is the role of Merkle trees in Cassandra's repair process? How do you add a new node to a Cassandra cluster? What is nodetool cleanup used for? How do you handle consistency across multiple datacenters in Cassandra?
Show more question and Answers...

Integration

Comments & Discussions