Why does Cassandra reject this query?
-- Cassandra (CQL) -- PRIMARY KEY ((user_id), ts) SELECT * FROM events WHERE kind = 'login';
- CQL has no
WHEREclause kindis a reserved keyword- It filters on a non-key column
- It needs a
JOINon users
Without the partition key Cassandra would scan every node; it refuses unless you add an index or
Play SQL & Databases ▸
ALLOW FILTERING.