cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Moses Dinakaran <>
Subject Re: Is it possible to delete records based upon where condition
Date Thu, 13 May 2010 11:11:32 GMT
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


On 5/13/10, Joel Pitt <> wrote:
> On Thu, May 13, 2010 at 12:34 AM, Moses Dinakaran
> <> 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 |
> OpenCog Developer |
> Board member, Humanity+ |

View raw message