incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Wille <rwi...@footnote.com>
Subject Re: Iterating through large numbers of rows with JDBC
Date Sun, 12 May 2013 14:51:46 GMT
Iterating through lots of records is not a primary use of my data.
However, there are a number scenarios where scanning the entire contents
of a column family is an interesting and useful exercise. Here are a few:
removal of orphaned records, checking the integrity a data set, and
analytics.

On 5/12/13 3:41 AM, "Oleg Dulin" <oleg.dulin@gmail.com> wrote:

>On 2013-05-11 14:42:32 +0000, Robert Wille said:
>
>> I'm using the JDBC driver to access Cassandra. I'm wondering if its
>> possible to iterate through a large number of records (e.g. to perform
>> maintenance on a large column family). I tried calling
>> Connection.createStatement(ResultSet.TYPE_FORWARD_ONLY,
>> ResultSet.CONCUR_READ_ONLY), but it times out, so I'm guessing that
>> cursors aren't supported. Is there another way to do this, or do I need
>>to
>> use a different API?
>> 
>> Thanks in advance
>> 
>> Robert
>
>If you feel that you need to iterate through a large number of rows
>then you are probably not using a correct data model.
>
>Can you describe your use case ?
>
>-- 
>Regards,
>Oleg Dulin
>NYC Java Big Data Engineer
>http://www.olegdulin.com/
>
>



Mime
View raw message