cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DuyHai Doan <doanduy...@gmail.com>
Subject Re: Does the default LIMIT applies to automatic paging?
Date Tue, 24 Jun 2014 19:35:34 GMT
Yes. And I advise to set fetchSize to a smaller value than 10 000. 1000 is
a good start. As long as there are still results, the iterator will fetch
data for you by batch of "fechtSize"


On Tue, Jun 24, 2014 at 9:03 PM, ziju feng <pkdogcom@gmail.com> wrote:

> Does that mean the iterator will give me all the data instead of 10000
> rows?
>
>
> On Mon, Jun 23, 2014 at 10:20 PM, DuyHai Doan <doanduyhai@gmail.com>
> wrote:
>
>> With the Java Driver,  set the fetchSize and use ResultSet.iterator
>> Le 24 juin 2014 01:04, "ziju feng" <pkdogcom@gmail.com> a écrit :
>>
>> Hi All,
>>>
>>> I have a wide row table that I want to iterate through all rows under a
>>> specific partition key. The table may contains around one million rows per
>>> partition
>>>
>>> I was wondering if the default 10000 rows LIMIT applies to automatic
>>> pagination in C* 2.0 (I'm using Datastax driver). If so, what is best way
>>> to retrieve all rows of a given partition? Should I use a super large LIMIT
>>> value or should I manually page through the table?
>>>
>>> Thanks,
>>>
>>> Ziju
>>>
>>
>

Mime
View raw message