Search code examples
cassandracqlcql3

Wide column pagination in CQL table

Let say i have this table

CREATE TABLE comments
(
    postId uuid,
    commentId timeuuid,
    postedBy text,
    postedById uuid,
    text text,
    blocked boolean,
    anonymous boolean,
    PRIMARY KEY(postId, commentId)
)

How can I perform wide column pagination on this table something like :

SELECT * FROM comments WHERE postId = '123' AND commentId > '34566'

I was going through Automatic Paging but confused with three approaches mentioned in this document that which should I use

Solution

  • If you want to compare field for timeuuid, you need to using the expression like below:

    SELECT * FROM comments WHERE postId = '123' AND commentId > maxTimeuuid('2013-08-01 15:05-0500')