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 <pkdog...@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 <doanduy...@gmail.com> > wrote: > >> With the Java Driver, set the fetchSize and use ResultSet.iterator >> Le 24 juin 2014 01:04, "ziju feng" <pkdog...@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 >>> >> >
