Hi Sachith, Could you try running the same query in a 2.x version and see what error is occurring ? As far as I know, it could be a tombstone issue, 1.x versions doesnt show it. If it gives an error of tombstone overwhelming in 2.x, then its the case what Madhawa has explained.
You manually can get rid of tombstones using nodetool by running flush command and then compaction. Regards, Hemika Hemika Kodikara Software Engineer WSO2 Inc. lean . enterprise . middleware http://wso2.com Mobile : +94777688882 On Tue, Sep 1, 2015 at 9:26 AM, Madhawa Gunasekara <madha...@wso2.com> wrote: > Hi Sachith, > > I'm not sure about this is the correct answer, but you can configure > gc_grace_seconds. It will help you to skip the OOM exception. > [1] http://docs.datastax.com/en/cql/3.0/cql/cql_reference/tabProp.html > > Thanks, > Madhawa > > On Mon, Aug 31, 2015 at 8:36 AM, Sachith Withana <sach...@wso2.com> wrote: > >> Hi all, >> >> I need to read a whole column family from a previous version of Cassandra >> (1.x). It works for a small result set ( for a CQL select * query). But >> for a larger dataset ( around 1 million records) it throws an out of memory >> exception (GC). >> >> Are there any mechanisms like paging for Cassandra 1.x? Or any other >> workaround for this issue? >> >> I observed that paging is supported from Cassandra 2.0 and above but not >> in the previous versions. >> >> >> Thanks. >> -- >> Sachith Withana >> Software Engineer; WSO2 Inc.; http://wso2.com >> E-mail: sachith AT wso2.com >> M: +94715518127 >> Linked-In: <http://goog_416592669> >> https://lk.linkedin.com/in/sachithwithana >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > *Madhawa Gunasekara* > Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > mobile: +94 719411002 <+94+719411002> > blog: *http://madhawa-gunasekara.blogspot.com > <http://madhawa-gunasekara.blogspot.com>* > linkedin: *http://lk.linkedin.com/in/mgunasekara > <http://lk.linkedin.com/in/mgunasekara>* > > _______________________________________________ > Dev mailing list > Dev@wso2.org > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
