You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Ajay (JIRA)" <ji...@apache.org> on 2015/02/13 12:33:11 UTC
[jira] [Updated] (CASSANDRA-8799) Pagination support in CQL and
henceforth in the drivers
[ https://issues.apache.org/jira/browse/CASSANDRA-8799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ajay updated CASSANDRA-8799:
----------------------------
Description:
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 to continue to the iteration.
was:
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.
> 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 to continue to the iteration.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)