On Thu, May 13, 2010 at 12:34 AM, Moses Dinakaran <mosesdinaka...@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
