Re: Will query on PK read entire partition?

2017-04-25 Thread Vladimir Yudovin
Hi, if you provide primary key C* will not scan whole partition, but will bloom filter to determinate SSTable: Cassandra uses Bloom filters to determine whether an SSTable has data for a particular row. Bloom filters are unused for range scans, but are used for index scans. Best

Re: Will query on PK read entire partition?

2017-04-21 Thread Alain RODRIGUEZ
Hi Oskar, My guess (wait for confirmation maybe): When you read from a primary key + specific clustering key or (range of clustering keys), Apache Cassandra will look for these specific values and not read all the row. Yet it is important to know that a minimal block size of 64 KB is read from

Will query on PK read entire partition?

2017-04-21 Thread Oskar Kjellin
If I have a table like this: PRIMARY KEY ((userid),deviceid) And I query SELECT * FROM devices where userid= ? and deviceid = ? Will cassandra read the entire partition for the userid? So if I lots of tombstones for userid, will they get scanned? I guess this depends on how the bloomfilter is