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,

Is it possible to delete records based upon where condition

2010-05-12 Thread Moses Dinakaran
Hi All, In Cassandra it possible to remove records based upon where condition. We are planning to move the session and cache table from MySql to Cassandra and where doing the fesability study. Everything seems to be Ok other than garbage collection of session table. Was not able to remove super