· 7 years ago · Feb 15, 2019, 08:38 AM
1CREATE TABLE IF NOT EXISTS keyspace.events (
2 date_string varchar,
3 starting_timestamp bigint,
4 event_name varchar,
5 sport_id varchar
6 PRIMARY KEY ((date_string), starting_timestamp, id)
7);
8
9SELECT * FROM keyspace.events
10WHERE
11 date_string IN ('', '', '') AND
12 starting_timestamp < '' AND
13 sport_id = 1 /* not in partitioning nor clustering key */
14ALLOW FILTERING;