Re: Large tombstones creation

2017-08-14 Thread Vlad
Hi, that's the issue, thanks! On Sunday, August 13, 2017 2:49 PM, Christophe Schmitz wrote: Hi Vlad, Are you by any chance inserting null values? If so you will create tombstones. The work around (Cassandra >= 2.2) is to use unset on your bound statement

Re: Large tombstones creation

2017-08-13 Thread Christophe Schmitz
Hi Vlad, Are you by any chance inserting null values? If so you will create tombstones. The work around (Cassandra >= 2.2) is to use unset on your bound statement (see https://issues.apache.org/jira/browse/CASSANDRA-7304) Cheers, Christophe On 13 August 2017 at 20:48, Vlad

Large tombstones creation

2017-08-13 Thread Vlad
Hi, I insert about 45000 rows to empty table in Python using prepared statements and IF NOT EXISTS. While reading after insert I get warnings likeServer warning: Read 5000 live rows and 33191 tombstone cells for query SELECT * FROM ...  LIMIT 5000 (see tombstone_warn_threshold) How it can