If you delete entire row, do the records in the row still get counted towards computing TombstoneOverwhelmingException? It seems like they still do.
From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: Saturday, August 09, 2014 3:21 AM To: user@cassandra.apache.org Subject: Re: Delete By Partition Key Implementation Thanks graham for the hints. I've digged into the source code and found out those 2 classes: https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/DeletionInfo.java https://github.com/apache/cassandra/blob/trunk/src/java/org/apache/cassandra/db/RangeTombstoneList.java They are quite self-explanatory. A deletion of an entire row is a single row tombstone, and yes there are range tombstones for marking deletion of a range of columns also On Aug 8, 2014, at 2:17 PM, Kevin Burton <bur...@spinn3r.com<mailto:bur...@spinn3r.com>> wrote: This is a good question.. I'd love to find out the answer. Seems like a tombstone with prefixes for the keys would work well. Also, can't any key prefixes work in theory? On Thu, Aug 7, 2014 at 8:33 AM, DuyHai Doan <doanduy...@gmail.com<mailto:doanduy...@gmail.com>> wrote: Hello all Usually, when using DELETE in CQL3 on some fields, C* creates tombstone columns for those fields. Now if I delete a whole PARTITION (delete from MyTable where partitionKey=...), what will C* do ? Will it create as many tombstones as there are physical columns on this partition or will it just mark this partition as "deleted" (Row Key deletion marker) ? On a side note, if I insert a bunch of physical columns in one partition with the SAME ttl value, after a while they will appear as expired, would C* need to scan the whole partition on disk to see which columns to expire or could it see that the whole partition is indeed expired thanks to meta data/ Partition key cache kept in memory ? I was thinking about the estimate histograms for TTL but I don't know in detail how it work Regards Duy Hai DOAN -- Founder/CEO Spinn3r.com<http://spinn3r.com/> Location: San Francisco, CA blog: http://burtonator.wordpress.com<http://burtonator.wordpress.com/> … or check out my Google+ profile<https://plus.google.com/102718274791889610666/posts> [cid:~WRD001.jpg]<http://spinn3r.com/> TD Securities disclaims any liability or losses either direct or consequential caused by the use of this information. This communication is for informational purposes only and is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. TD Securities is neither making any investment recommendation nor providing any professional or advisory services relating to the activities described herein. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice Any products described herein are (i) not insured by the FDIC, (ii) not a deposit or other obligation of, or guaranteed by, an insured depository institution and (iii) subject to investment risks, including possible loss of the principal amount invested. The information shall not be further distributed or duplicated in whole or in part by any means without the prior written consent of TD Securities. TD Securities is a trademark of The Toronto-Dominion Bank and represents TD Securities (USA) LLC and certain investment banking activities of The Toronto-Dominion Bank and its subsidiaries.