Learning Apache Cassandra - Second Edition

Secondary indexes can only be tested for equality

In the section on Retrieving status updates for a specific time range in Chapter 4, Beyond Key-Value Lookup, we explored the use of inequality operators to select ranges of columns. Secondary indexes can only be queried for equality; queries such as the following are not possible:

SELECT * FROM "user_follows" WHERE "follower_username" > 'alice';