Learning Apache Cassandra - Second Edition

Paginating over multiple partitions

Returning to our original user_status_updates table, we might in certain situations, for an administrative interface, for instance display all of the status updates in the system. In this case, we will certainly want the ability to paginate, as the total collection of status updates will get very large.

As in our previous example, let's use a page size of three. The query for the first page is simple enough:

SELECT * FROM "user_status_updates"LIMIT 3;

As expected, we'll get back bob's first three status updates:

For the second page, things get a bit more complicated. We know that the last row we retrieved ...