Return-Path: Delivered-To: apmail-cassandra-dev-archive@www.apache.org Received: (qmail 20464 invoked from network); 23 May 2010 14:38:20 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 23 May 2010 14:38:20 -0000 Received: (qmail 4704 invoked by uid 500); 23 May 2010 14:38:20 -0000 Delivered-To: apmail-cassandra-dev-archive@cassandra.apache.org Received: (qmail 4671 invoked by uid 500); 23 May 2010 14:38:20 -0000 Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list dev@cassandra.apache.org Received: (qmail 4663 invoked by uid 99); 23 May 2010 14:38:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 23 May 2010 14:38:20 +0000 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=AWL,FREEMAIL_FROM,HTML_MESSAGE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of jan.virin@gmail.com designates 209.85.161.44 as permitted sender) Received: from [209.85.161.44] (HELO mail-fx0-f44.google.com) (209.85.161.44) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 23 May 2010 14:38:15 +0000 Received: by fxm12 with SMTP id 12so1998642fxm.31 for ; Sun, 23 May 2010 07:37:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:content-type; bh=b5JDzEZexT7hIMzo0hysJdI5vHLcRo0ialmAaFGgtwc=; b=kFNPVxzW6vmLEmWvM6bKNjKaOb939QihVYrHiNVqfkVC41Fw8bhEO7dkfVT4rkHS8v 3Zdad+0PbuklJbGBppdkA56VOpEvr/Ga0eVSjRwUEPdGq0kM5t1zkLJM0aa+MHR9VXkN hPG/T48VTeI+7gmjbhaXhBPDbvgfYDzT35ZsQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=wVFQA1iz9f9yvJzoV7n3cUqJe6XI8s3FiIWDkzvQ+XKVy6ZPMajjIxZWITYmHMV4W0 UoLICSvou6k6K5D0XeFdRuzFwzIA8MTG3+fRnk9HKL4EKpWkH556uWOxUmeXCMU9IIXM ncLXjWxJEfFbFLl9BmodyEkE9InvNCk6P6Qqc= MIME-Version: 1.0 Received: by 10.223.64.205 with SMTP id f13mr3559827fai.98.1274625473835; Sun, 23 May 2010 07:37:53 -0700 (PDT) Received: by 10.223.110.84 with HTTP; Sun, 23 May 2010 07:37:53 -0700 (PDT) In-Reply-To: References: Date: Sun, 23 May 2010 17:37:53 +0300 Message-ID: Subject: Re: Go over super column data and delete the first X rows From: Yan Virin To: dev@cassandra.apache.org Content-Type: multipart/alternative; boundary=001517402dc296f44c048743de96 --001517402dc296f44c048743de96 Content-Type: text/plain; charset=ISO-8859-1 I understand, I wanted to know how exactly should I do it manually... is there some "best" practice of going over all the "older" rows and deleting them? On Sun, May 23, 2010 at 5:25 PM, Jonathan Ellis wrote: > Answered on the user@ list. > > On Sun, May 23, 2010 at 3:35 AM, Yan Virin 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 > -- Jan Virin http://www.linkedin.com/in/yanvirin --001517402dc296f44c048743de96--