cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ajay (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-8799) Pagination support in CQL and henceforth in the drivers
Date Fri, 13 Feb 2015 11:23:11 GMT
Ajay created CASSANDRA-8799:
-------------------------------

             Summary: 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 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 as well. 

As I mentioned in the forum discussion as well, the oagination support is best done in the
Casssandra core like TOP, ROWNUM, LIMIT in SQL. 

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 implicit pagination through https://issues.apache.org/jira/browse/CASSANDRA-4415.
Suggestion : 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. Accept
the FetchingState on the ResultSet to continue to the iteration.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message