Conditional querying
We can do conditional querying in Cassandra using the WHERE
clause. These conditions can be made using primary key and/or secondary indexed columns.
Conditions on a partition key
Only equality or IN
relations are allowed on the queries based on the partition key. Also, IN
relations are only allowed on the last part of the partition key. A complete partition key is required in query condition. For example, in the cars_ratings_by_table
column family, only the following queries are allowed:
SELECT * FROM cars_ratings_by_brand WHERE brand = 'Audi' and model = 'Q7' SELECT * FROM cars_ratings_by_brand WHERE brand = 'Audi' and model = 'Q7' SELECT * FROM cars_ratings_by_brand WHERE brand = 'Maruti' AND model IN ('Q7', 'Swift')
The following ...
Get Apache Cassandra Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.