Re: How many tombstones for deleted CQL row?

2014-12-31 Thread Tyler Hobbs
On Fri, Dec 26, 2014 at 5:50 AM, Jens Rantil jens.ran...@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/


How many tombstones for deleted CQL row?

2014-12-26 Thread Jens Rantil
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?

2014-12-26 Thread DuyHai Doan
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 jens.ran...@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?

2014-12-26 Thread Jens Rantil
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 doanduy...@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 jens.ran...@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