Caution
You are not reading the most current version of the documentation. If you want up-to-date information, please have a look at 3.9 .
Scylla supports server-side data filtering that is not based on the primary key. This means Scylla would execute a full scan on the table: read all of the table’s data from disk, and then filter and return part of it to the user. More information on ALLOW FILTERING.
These kinds of queries can create a bigger load on Scylla, and should be used with care.