You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Jens Rantil <je...@tink.se> on 2014/12/26 10:50:02 UTC

How many tombstones for deleted CQL row?

Hi,

I am considering tuning the tombstone warn/error threshold.

Just making sure; If I INSERT one (CQL) row populating all six columns and
then DELETE the inserted row, will Cassandra write 1 "range tombstone" or
seven tombstones (one per columns plus "row marker")?

Thanks,
Jens

Re: How many tombstones for deleted CQL row?

Posted by Tyler Hobbs <ty...@datastax.com>.
On Fri, Dec 26, 2014 at 5:50 AM, Jens Rantil <je...@tink.se> wrote:

> Great. Also, if I issue "DELETE my_table WHERE partition_key=xxx AND
> compound_key=yyy" I understand only a single tombstone will be created?


That's correct, it will create one range tombstone.


-- 
Tyler Hobbs
DataStax <http://datastax.com/>

Re: How many tombstones for deleted CQL row?

Posted by Jens Rantil <je...@tink.se>.
Great. Also, if I issue "DELETE my_table WHERE partition_key=xxx AND compound_key=yyy" I understand only a single tombstone will be created?

On Fri, Dec 26, 2014 at 10:59 AM, DuyHai Doan <do...@gmail.com>
wrote:

> If you issue "DELETE my_table WHERE partition_key = xxx" Cassandra will
> create a "row tomstone" and not one tombstone per column, fortunately
> On Fri, Dec 26, 2014 at 10:50 AM, Jens Rantil <je...@tink.se> wrote:
>> Hi,
>>
>> I am considering tuning the tombstone warn/error threshold.
>>
>> Just making sure; If I INSERT one (CQL) row populating all six columns and
>> then DELETE the inserted row, will Cassandra write 1 "range tombstone" or
>> seven tombstones (one per columns plus "row marker")?
>>
>> Thanks,
>> Jens
>>

Re: How many tombstones for deleted CQL row?

Posted by DuyHai Doan <do...@gmail.com>.
If you issue "DELETE my_table WHERE partition_key = xxx" Cassandra will
create a "row tomstone" and not one tombstone per column, fortunately

On Fri, Dec 26, 2014 at 10:50 AM, Jens Rantil <je...@tink.se> wrote:

> Hi,
>
> I am considering tuning the tombstone warn/error threshold.
>
> Just making sure; If I INSERT one (CQL) row populating all six columns and
> then DELETE the inserted row, will Cassandra write 1 "range tombstone" or
> seven tombstones (one per columns plus "row marker")?
>
> Thanks,
> Jens
>