cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joel Pitt <joel.p...@gmail.com>
Subject Re: Is it possible to delete records based upon where condition
Date Wed, 12 May 2010 20:18:19 GMT
On Thu, May 13, 2010 at 12:34 AM, Moses Dinakaran
<mosesdinakaran@gmail.com> wrote:
> I wanted to remove the records based upon the value of the column ses_tstamp
> ie (delete from sessions where ses_tstamp between XXX & YYY OR delete from
> session where ses_tstamp < XXX )
>
> Is it possible to achieve this in Cassandra If so  please let me know how.

>From my limited understanding of Cassandra (haven't actually deployed
it and have mostly just been learning from reading for now) the way
you'd want to do this is by either rearranging your schema (or
manually creating an index) so that the timestamps are used as the
column names within a CF that is sorted by the timestamp.

Joel Pitt, PhD | http://ferrouswheel.me
OpenCog Developer | http://opencog.org
Board member, Humanity+ | http://humanityplus.org

Mime
View raw message