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
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
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