$ ./guess_the_languageSQL & Databases
SQL & Databases · hard · #59

Why does Cassandra reject this query?

-- Cassandra (CQL)
-- PRIMARY KEY ((user_id), ts)
SELECT * FROM events
WHERE kind = 'login';
  1. CQL has no WHERE clause
  2. kind is a reserved keyword
  3. It filters on a non-key column
  4. It needs a JOIN on users
Without the partition key Cassandra would scan every node; it refuses unless you add an index or ALLOW FILTERING.
Play SQL & Databases ▸