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
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
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,
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