[
https://issues.apache.org/jira/browse/CASSANDRA-8799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14547872#comment-14547872
]
Ajay commented on CASSANDRA-8799:
---------------------------------
I meant like ROWNUM in Oracle SQL
select * from t where ROWNUM > 1;
http://www.oracle.com/technetwork/issue-archive/2006/06-sep/o56asktom-086197.html
http://docs.oracle.com/cd/B14117_01/server.101/b10759/pseudocolumns008.htm
> 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)
