incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Burton <bur...@spinn3r.com>
Subject Re: Delete By Partition Key Implementation
Date Fri, 08 Aug 2014 19:17:14 GMT
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 <doanduyhai@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
Location: *San Francisco, CA*
blog: http://burtonator.wordpress.com
… or check out my Google+ profile
<https://plus.google.com/102718274791889610666/posts>
<http://spinn3r.com>

Mime
View raw message