Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=Z01gBX6BR4gOFknZXEYQylTO4S51QIfsyVvukjt4ZMMOYex1i8wX+nwmdcoCOZsUPW
         olKMGog7KdNy7/Ar0UgxMYOGCkZNVCzqNR22LoPVuU/mS8/nA84t3sal/Ic4IYgARmDR
         4slYaBLU+5YzkbgDA/aJ32OhBO6yOqVYUeKdg=
MIME-Version: 1.0
In-Reply-To: <AANLkTim983ux_nHkgtEsC0h5KhojRF2T1PE6XKJ7pprK@mail.gmail.com>
References: <AANLkTim983ux_nHkgtEsC0h5KhojRF2T1PE6XKJ7pprK@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Sun, 23 May 2010 09:26:06 -0500
Message-ID: <AANLkTimWZLS25ABCcOs2wdJyGK-fmJr2q7e3M0Hr0_Ha@mail.gmail.com>
Subject: Re: Go over super column data and delete the first X rows
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

the TTL (expiring columns) feature in 0.7 is the easiest way to do
this.  Until then you'd have to delete them manually.

On Sun, May 23, 2010 at 3:35 AM, Yan Virin <jan.virin@gmail.com> wrote:
> Hi
> I want to use cassandra for storing some data which gets irrelevant with
> time. There will be a lot of data and I want to run a procedure which will
> delete the oldest from the repository from time to time.
> The column name which holds the data is a "timestamp" name, so I will want
> delete some range of it from the repository.
> What is the most efficient and the easiest way to do this?
>
> Thanks,
>
> --
> Jan Virin
> http://www.linkedin.com/in/yanvirin
>


-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com