cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ajay (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8799) Pagination support in CQL and henceforth in the drivers
Date Mon, 18 May 2015 11:05:01 GMT

    [ 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/user@cassandra.apache.org/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)

Mime
View raw message