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