Search Restrictions Solution: Denormalization

In Apache Cassandra, the table's primary key imposes restrictions on search conditions, impacting design of the relational model. In this lesson we will focus on these limitations and denormalization as a potential solution.

To reiterate, in a SELECT query:

• Only the columns that are part of the primary key can be used in the WHERE clause as filtering conditions.

• Only equality searches can be performed on partition key columns. Range queries are allowed on clustering columns.

• If the partition key is composed of multiple columns (composite partition key), all partition key columns must be included in the WHERE clause. 

• Clustering columns may not be included in the search condition. To include a clustering column in the WHERE clause, all clustering columns defined ...