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 7B5161027D for ; Wed, 9 Oct 2013 18:57:11 +0000 (UTC) Received: (qmail 94615 invoked by uid 500); 9 Oct 2013 18:56:52 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 94526 invoked by uid 500); 9 Oct 2013 18:56:49 -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 94408 invoked by uid 99); 9 Oct 2013 18:56:44 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Oct 2013 18:56:44 +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 (nike.apache.org: domain of shahab.yunus@gmail.com designates 209.85.214.47 as permitted sender) Received: from [209.85.214.47] (HELO mail-bk0-f47.google.com) (209.85.214.47) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Oct 2013 18:56:38 +0000 Received: by mail-bk0-f47.google.com with SMTP id mx12so526358bkb.20 for ; Wed, 09 Oct 2013 11:56:17 -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=qKYIEBDH2xwUX+qJ+D7MdNIKqL//5A2zTTjiKDozhN8=; b=QuKUX8h1Ct015fU8t/gKqOxUC8kqvuWr23fm8bcee5RnRq9VRiiCowBmo08RDw1RTH JVlRctSKo1B49opLeNVf0xMJMz1HASxbRxMhK80PxBexDy3VOuzn8Psa2hdLn85cAYwu 8I4JQNVcdaEJyjl6LmENXyPQHYO+wTYV2LeYLI/RWG0boHP9Jh30CEK3XtHRelRfdTSw yU8DjkV7NVKkdJMj3rNKn0R9g1QLdpK4win5CMWqZVNhrGQcIbU+oLwgng+HhYT90jUy kF5w83PbXkyyAqi5d2tPSGrolLEUe0f9R3tKAis/MCYocVheeSMnGTKoClPMukBrH7aa UxOQ== MIME-Version: 1.0 X-Received: by 10.205.65.78 with SMTP id xl14mr8247290bkb.1.1381344977869; Wed, 09 Oct 2013 11:56:17 -0700 (PDT) Received: by 10.204.238.131 with HTTP; Wed, 9 Oct 2013 11:56:17 -0700 (PDT) In-Reply-To: References: Date: Wed, 9 Oct 2013 14:56:17 -0400 Message-ID: Subject: Re: Deleting data using timestamp From: Shahab Yunus To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=bcaec5430d4eb8041d04e853709e X-Virus-Checked: Checked by ClamAV on apache.org --bcaec5430d4eb8041d04e853709e Content-Type: text/plain; charset=ISO-8859-1 Ahh, yes, 'compaction'. I blanked out while mentioning repair and cleanup. That is in fact what needs to be done first and what I meant. Thanks Robert. Regards, Shahab On Wed, Oct 9, 2013 at 1:50 PM, Robert Coli wrote: > On Wed, Oct 9, 2013 at 7:35 AM, Ravikumar Govindarajan < > ravikumar.govindarajan@gmail.com> wrote: > >> What is the quick way to delete old-data and at the same time make sure >> read [doesn't] churn through all deleted columns? >> > > Use a database that isn't log structured? > > But seriously, in 2.0 there's this : > > https://issues.apache.org/jira/browse/CASSANDRA-5514 > > Which allows for timestamp hints at query time. > > And... > > https://issues.apache.org/jira/browse/CASSANDRA-5228 > > Which does compaction expiration of entire SSTables based on TTL. > > =Rob > > --bcaec5430d4eb8041d04e853709e Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Ahh, yes, 'compaction'. I blanked out while mentio= ning repair and cleanup. That is in fact what needs to be done first and wh= at I meant. Thanks Robert.=A0

Regards,
Shahab<= /div>


On Wed,= Oct 9, 2013 at 1:50 PM, Robert Coli <rcoli@eventbrite.com> wrote:
On Wed, Oct 9, 2013 at 7:35= AM, Ravikumar Govindarajan <ravikumar.govindarajan@gmail.c= om> wrote:
What is t= he quick way to delete old-data and at the same time make sure read [doesn&= #39;t] churn through all deleted columns?

Use a database that isn't log st= ructured?

But seriously, in 2.0 there's this :=


Which allows for timestamp hints at query time.

And...
=A0

Which does compaction expiration of entire SSTabl= es based on TTL.

=3DRob

=

--bcaec5430d4eb8041d04e853709e--