Hi Thanks for the answers, we are planning to run a cron job that fetches the record and deletes one by one. A post which gives more details on this http://www.mail-archive.com/[email protected]/msg02610.html
Regards, Moses. On 5/13/10, Joel Pitt <[email protected]> wrote: > On Thu, May 13, 2010 at 12:34 AM, Moses Dinakaran > <[email protected]> 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 >
