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
>