I have live datacenter with standalone Cassandra db holding huge data sets. As a part of requirement I want to clean us a specific user data in my system which is nothing but partition key of my tables. How efficiently can I achieve this deletion process in live systems.
Bringing together the Apache Cassandra experts from the community and DataStax.
Want to learn? Have a question? Want to share your expertise? You are in the right place!
Not sure where to begin? Getting Started
There's really not much to it -- deleting whole partitions do not suffer from the same problem as deleting rows inside partitions.
Just make sure you don't overload your cluster since deletes in Cassandra are "inserts" under-the-hood (inserts a tombstone) so they are regular writes and it is possible to flood the nodes with lots of deletes/writes. Cheers!
Thanks @Erick Ramirez for sharing your thoughts.
Separately, On the similar lines I do have requirements to delete some rows within specific partitions, what should I, ideally be taking care in this scenario?
Provided you're
not using Cassandra for queue management then it should be fine. Cheers!
Each of the delete operation will result in a single tombstone. If you are able to delete more data in a single command the fewer tombstones you will have. If your application is generating large number of tombstones Cassandra’s read performance will be impacted.
Deleting the data at the largest granularity ideally entire partitions at once. This will minimize the number of tombstones.
In your case you can delete the entire row I believe.
7 People are following this question.
