Thank you all for your answers and clarification. The reason I mentioned the 10000 rows LIMIT is not only because it is the default LIMIT in cqlsh, but also because I found it on the CQL document <http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/select_r.html>, specifically the "Specifying rows returned using LIMIT" section. Perhaps the document needs some updates to clarify a bit about what applies to the drivers and what applies to cqlsh?
On Wed, Jun 25, 2014 at 12:21 AM, Sylvain Lebresne <sylv...@datastax.com> wrote: > On Tue, Jun 24, 2014 at 1:03 AM, ziju feng <pkdog...@gmail.com> wrote: > >> >> I was wondering if the default 10000 rows LIMIT applies to automatic >> pagination in C* 2.0 (I'm using Datastax driver). >> > > There is no "10000 rows LIMIT" in CQL. cqlsh does apply a default LIMIT if > you don't provide for convenience sake, but it's a cqlsh thing. Therefore, > there is no default limit with the java driver (neither with or without > automatic pagination). > > -- > Sylvain > >
