Database Reference
In-Depth Information
Chapter 4. Beyond Key-Value Lookup
In the last chapter, we explored a powerful data organization concept in Cassandra—the
compound primary key. This allowed us to construct a table for status updates that satisfies
two important requirements: related data is grouped together, and records have a built-in
ordering within each group. So far, however, we only have two tools for querying data:
either retrieve a single row using its full primary key, or retrieve all the rows in a table. In
this chapter, we will dive into the more sophisticated queries that are available on tables
with clustering columns, and use these queries to build the main reading interface for our
MyStatus application. By the end of this chapter, you'll know:
• How to retrieve all rows within a single partition
• How to retrieve rows within a range of clustering column values
• How to paginate over rows in a single partition
• How to change the order of results
• How to store rows in descending order of clustering column
• How to paginate over all rows in a compound primary key table
• How to construct autocomplete functionality using a compound primary key table
