CODEWITHSUNDEEP
javacassandraastyanax
Moditha Dharmasiri
Moditha Dharmasiri

Reputation: 55

How to increase default maximum number of rows in Astyanax?

Hi I am using Astyanax client to access Cassandra with CQL inside my program. The problem I'm having is that when I execute a query the number of rows of the OperationResult is set to a maximum of 10 000. I need to increase this limit for my needs. Pagination cannot be done when using CQL with Astyanax. If anybody could point me into a right direction that would be really helpful. Thanks in advance

Upvotes: 1

Views: 642

Answers (2)

Moditha Dharmasiri
Moditha Dharmasiri

Reputation: 55

It is in the query the default limit is 10000 you need to specify the limit within the query.

http://www.datastax.com/docs/1.0/references/cql/SELECT

has the answer

Upvotes: 2

Christos Kalantzis
Christos Kalantzis

Reputation: 36

Astyanax, when using CQL, does not limit how many rows are returned. You may want to check your Cassandra configuration. I would warn that returning too many rows may cause other issues at the client level, like running out of memory.

Cheers

Upvotes: 2

Related Questions