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/[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 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)
