[
https://issues.apache.org/jira/browse/CASSANDRA-8799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne resolved CASSANDRA-8799.
-----------------------------------------
Resolution: Duplicate
> Pagination support in CQL and henceforth in the drivers
> -------------------------------------------------------
>
> Key: CASSANDRA-8799
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8799
> Project: Cassandra
> Issue Type: New Feature
> Components: Core, Drivers (now out of tree)
> Reporter: Ajay
>
> Currently Cassandra doesn't support pagination(explicit) and henceforth the
> drivers either.
> To achieve the same the client has to do the workaround as mentioned in the
> below blog (section Cql3 pagination)
> www.datastax.com/dev/blog/cql3-table-support-in-hadoop-pig-and-hive
> Before raising this enhancement, I initiated a discussion in Cassandra users
> forum and Java driver users forum as below:
> http://www.mail-archive.com/[email protected]/msg40864.html
> Even if it is not possible to support Pagination, I would like to know the
> technical reasons.
> Pagination support is important in any database query and especially in NoSQL
> as we deal with large number of rows. It is very common usecase as well.
> As I mentioned in the forum discussion, the pagination support is best done
> in the Casssandra core like TOP, ROWNUM, LIMIT in SQL. (LIMIT is already
> supported in Cassandra)
> If it is not possible to support pagination in CQL, could it be supported in
> Java driver (other drivers as well)?, as it is already supporting the
> implicit pagination through
> https://issues.apache.org/jira/browse/CASSANDRA-4415. The
> Multipage.FetchingState can be made immutable and returned on each page query
> and the driver cache it in the session level or expose it to the client to
> cache it to continue the iteration to the next page.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
