Cassandra - Allow Filtering example

less than 1 minute read

1
2
3
4
5
6
7
create table User(
    email text,
    name text,
    desc text,
    user_id uuid
    PRIMARY KEY((email), name, user_id)
) WITH CLUSTERING ORDER BY (name DESC, user_id ASC);

Allow Filtering can only work with the clustering key.

1
select * from user where name = 'Test' allow filtering;

Some useful cassandra commands

1
/>list users limit 3;