Skip to Content
Mastering Apache Cassandra 3.x - Third Edition
book

Mastering Apache Cassandra 3.x - Third Edition

by Aaron Ploetz, Tejaswi Malepati
October 2018
Beginner to intermediate content levelBeginner to intermediate
348 pages
10h
English
Packt Publishing
Content preview from Mastering Apache Cassandra 3.x - Third Edition

The IN operator

So we've seen that CQL has an AND keyword for specifying multiple filters in the WHERE clause. Does it also have an OR keyword, like SQL?

No, it does not. This is because Apache Cassandra is designed to serve sequential reads, not random reads. It works best when its queries give it a clear, precise path to the requested data. Allowing filters in the WHERE clause to be specified on an OR basis would force Cassandra to perform random reads, which really works against how it was built.

However, queries can be made to perform similarly to OR, via the IN operator:

SELECT * FROM query_test WHERE pk1='a' AND pk2 IN ('b','c');

While this query technically will work, its use is considered to be an anti-pattern in Cassandra. This is ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Apache Cassandra - Second Edition

Mastering Apache Cassandra - Second Edition

Nishant Neeraj

Publisher Resources

ISBN: 9781789131499Supplemental Content