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;

You may also enjoy