Re: High Bloom filter false ratio

2016-02-22 Thread Jeff Jirsa
There exists a JMX endpoint called forceUserDefinedCompaction that takes a comma separated list of sstables to compact together. There also exists a tool called sstablemetadata (may be in a ‘cassandra-tools’ package separate from whatever package you used to install cassandra, or in the tools/

Re: High Bloom filter false ratio

2016-02-22 Thread Anishek Agarwal
Hey Jeff, Thanks for the clarification, I did not explain my self clearly, the max_stable_age_days is set to 30 days and the ttl on every insert is set to 30 days also by default. gc_grace_seconds is 0, so i would think the sstable as a whole would be deleted. Because of the problems mentioned by

Isolation for atomic batch on the same partition key

2016-02-22 Thread Yawei Li
Hi all, A couple of questions about atomic batch: 1. If an atomic batch (logged batch) contains a bunch of row mutations and all of them have the same partition key, can I assume all those changes have the same isolation as the row-level isolation? According to the post here http://www.mail-archi

[Announcement] Achilles 4.1.0 released

2016-02-22 Thread DuyHai Doan
Hello all I am pleased to announce the release of Achilles 4.1.0. The biggest change is the support for new Cassandra 3.x Materialized View by annotation. Achilles also enforces constraints on your views (all primary key columns of the base table should be in the view etc..) at compile time an

Cassandra Calcite integration

2016-02-22 Thread Michael Mior
Hi all, For those not familiar, Apache Calcite is a data management framework that enables storage-agnostic SQL query processing. The practical implications are that by writing a relatively small amount of code, Calcite can execute a large subset of SQL queries against different backend databases.

Re: High Bloom filter false ratio

2016-02-22 Thread Jeff Jirsa
1) getFullyExpiredSSTables in 2.0 isn’t as thorough as many expect, so it’s very likely that some sstables stick around longer than you expect. 2) max_sstable_age_days tells cassandra when to stop compacting that file, not when to delete it. 3) You can change the window size using both the base

Re: High Bloom filter false ratio

2016-02-22 Thread Christopher Bradford
Does every record in the SSTable have a "d" column? On Mon, Feb 22, 2016 at 2:14 AM Anishek Agarwal wrote: > Hey guys, > > Just did some more digging ... looks like DTCS is not removing old data > completely, I used sstable2json for one such table and saw old data there. > we have a value of 30