Re: Is it possible to delete records based upon where condition

2010-05-13 Thread Moses Dinakaran
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/cassandra-u...@incubator.apache.org/msg02610.html Regards, Moses. On 5/13/10, Joel Pitt wrote: > On Thu, May 13, 2010 a

Re: Is it possible to delete records based upon where condition

2010-05-12 Thread Joel Pitt
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

Re: Is it possible to delete records based upon where condition

2010-05-12 Thread Benjamin Black
The functionality of a WHERE clause usually means maintaining an inverted index, usually another CF, on the information of interest (ses_tstamp in your example). You then retrieve index rows from that CF to find the data rows. b On Wed, May 12, 2010 at 5:34 AM, Moses Dinakaran wrote: > Hi All,