O'Reilly logo

Apache Cassandra Essentials by Nitin Padalia

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required