Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4E6F4EAD4 for ; Wed, 29 May 2013 14:30:48 +0000 (UTC) Received: (qmail 89782 invoked by uid 500); 29 May 2013 14:30:45 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 89653 invoked by uid 500); 29 May 2013 14:30:45 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 89637 invoked by uid 99); 29 May 2013 14:30:45 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 May 2013 14:30:45 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of cayiroglu@gmail.com designates 209.85.212.178 as permitted sender) Received: from [209.85.212.178] (HELO mail-wi0-f178.google.com) (209.85.212.178) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 May 2013 14:30:40 +0000 Received: by mail-wi0-f178.google.com with SMTP id hj6so3562970wib.11 for ; Wed, 29 May 2013 07:30:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=GqeN36hqILovtQpPIVcRxZPl9mwY1Z/pxZtKATawUH0=; b=oExzydJQDL5gWGhJdaRgb0x6XzScW/LXeWY2BNyeHpEQy2sFSf3VBJjvwbbWG+Xq9z Rai2YAZ/rV/5S2beX6XNtKkQgXLb+gF3WO4LtNjAMaSxxXkPmVXbg43uCB2wGXmK0v0J qcbGdmJVuO3FJYvHUlt/8v4Z2ISFAuLTQZ/hQtmdSMbzWUqqrXzjX/fVU0n1F9QYtsOH EIIlcaqMv84EESQklYYiRCqxDsJSymJhGAUTXxkSYfwvXe46raJHBsfdhQhijsqRQZ4S wxy2DfrV9Ajz7Clx2asS781pMydatqeBcIMv6F1I+OP+gSfczjbtcyoUpEpgyG1vqZcn RygA== MIME-Version: 1.0 X-Received: by 10.194.19.3 with SMTP id a3mr1794725wje.54.1369837819691; Wed, 29 May 2013 07:30:19 -0700 (PDT) Received: by 10.194.0.238 with HTTP; Wed, 29 May 2013 07:30:19 -0700 (PDT) In-Reply-To: References: Date: Wed, 29 May 2013 16:30:19 +0200 Message-ID: Subject: Re: data clean up problem From: cem To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=047d7b450c20a4882404dddc3847 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b450c20a4882404dddc3847 Content-Type: text/plain; charset=ISO-8859-1 Thanks for the answers! Cem On Wed, May 29, 2013 at 1:26 AM, Robert Coli wrote: > On Tue, May 28, 2013 at 2:38 PM, Bryan Talbot > wrote: > > I think what you're asking for (efficient removal of TTL'd write-once > data) > > is already in the works but not until 2.0 it seems. > > If your entire dataset in a keyspace or column family is deleted every > [small time period], then maybe use TRUNCATE? > > Two caveats : > > 1) https://issues.apache.org/jira/browse/CASSANDRA-4655 - TRUNCATE > will leave undelivered hints untouched until 1.2.6 > 2) TRUNCATE will create a snapshot unless you (unsafely!!!!!!! > danger!!!!!!!!) disable this feature [1] > > Alternately, perhaps a datastore with immutable data files is not for you? > :D > > =Rob > [1] https://issues.apache.org/jira/browse/CASSANDRA-3710 > --047d7b450c20a4882404dddc3847 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Thanks for the answers!

Cem


On Wed, May 29, 2013 at 1:26 AM, Robert Coli <rcoli@eventbrite.co= m> wrote:
On Tue, May 28, 2013 at 2:= 38 PM, Bryan Talbot <btalbot@a= eriagames.com> wrote:
> I think what you're asking for (efficient removal of TTL'd wri= te-once data)
> is already in the works but not until 2.0 it seems.

If your entire dataset in a keyspace or column family is deleted ever= y
[small time period], then maybe use TRUNCATE?

Two caveats :

1) https://issues.apache.org/jira/browse/CASSANDRA-4655 - TRUN= CATE
will leave undelivered hints untouched until 1.2.6
2) TRUNCATE will create a snapshot unless you (unsafely!!!!!!!
danger!!!!!!!!) disable this feature [1]

Alternately, perhaps a datastore with immutable data files is not for you? = :D

=3DRob
[1] https://issues.apache.org/jira/browse/CASSANDRA-3710

--047d7b450c20a4882404dddc3847--