The First Table - Learning Apache Cassandra - page 44

SELECT * FROM "users"
WHERE token("username") > token('dave')
LIMIT 2;
And just as we'd hoped, the next two rows are returned as shown below:
Using this technique, we can paginate over arbitrarily large tables using multiple queries.
Note
It bears emphasizing that retrieving large result sets from tables structured like users is a
relatively expensive operation for Cassandra. In Chapter 3 , Organizing Related Data ,
we'll begin to develop a more advanced table structure that will allow us to retrieve
batches of rows very efficiently.