How do I handle deletions that avoids tombstone warnings?

Question

question

resolve123_170609 asked Nov 20, '20 Erick Ramirez edited Nov 20, '20

How do I handle deletions that avoids tombstone warnings?

Hi , I have tombstone issue in Cassandra for delete records. I have table with date column as partition key. Every day new records come and I have to delete previous date partition key. I noticed it is giving tombstone warning. Is there any way to handle it.

tombstones

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Privacy Policy Terms of Use

Answer 1 · 2020-11-20T19:05:35Z

smadhavan answered Nov 20, '20 resolve123_170609 commented Nov 20, '20

@resolve123_170609, there is no enough details as to the version, stack, etc., and there is already a good post that you could refer to here to understand how the tombstones work and how to deal with it. Please also refer to other discussion here on the community about tombstones.

1 Share

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

resolve123_170609 commented · Nov 20, 2020 at 10:21 PM

I understand tombstone but my requirement is i have to delete rows on daily basis.

Cassandra version 3.11.6 i have table with date as partition key. every day i have to delete the historical data of past 30 days it means 30 partition data i have to delete.

0 ·

question