Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-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 DA40211AC3 for ; Tue, 2 Sep 2014 18:43:58 +0000 (UTC) Received: (qmail 47918 invoked by uid 500); 2 Sep 2014 18:43:56 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 47847 invoked by uid 500); 2 Sep 2014 18:43:56 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 47836 invoked by uid 99); 2 Sep 2014 18:43:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Sep 2014 18:43:56 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.220.172] (HELO mail-vc0-f172.google.com) (209.85.220.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Sep 2014 18:43:29 +0000 Received: by mail-vc0-f172.google.com with SMTP id ij19so7664088vcb.3 for ; Tue, 02 Sep 2014 11:43:28 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=nE/YiLRmL6xb2qDAcejRJ11z7nih/REuaE6gxe2lFhs=; b=QdCvfMCLIhqqn6EAwjK55spueiMsC7KZYduKKa1YCTuNuu15QA5fUk9x8b37h8gk6/ 8DFM3PkuS2CqKbvD6gEG87oHbRR5kMHxyBTz8h4Fd6UvVDU5YwbvZS++t9oFk4wteMVD m4bxwo2CVtsY/WoCm+vcPuVf4Hk6dCSPau3q6vBUTSAdGrenQEQnVlbLjCa/7sGBKe8X 2y8YOmVBNQMakzS7XnOjyrq4rjqZYDL5nKj+uYH5eqQc05+/KR2nJA5/mt2FR9h+tfL1 fE5O8WAqqnerK9vCxnM/923/UOT45Crs5TuHTjrDLuwV8ntaSFO9MTEpzGc1+AnWb5Qu iwTQ== X-Gm-Message-State: ALoCoQkffIiebFc9baT1Y+bH1go8XkWl+hw8Ou/MriqRAJCNKJZkcHnnZhalmSc0WeB+hGe19c55 X-Received: by 10.53.7.225 with SMTP id df1mr11125287vdd.9.1409683408622; Tue, 02 Sep 2014 11:43:28 -0700 (PDT) MIME-Version: 1.0 Received: by 10.52.100.227 with HTTP; Tue, 2 Sep 2014 11:43:08 -0700 (PDT) In-Reply-To: References: From: Jean-Marc Spaggiari Date: Tue, 2 Sep 2014 14:43:08 -0400 Message-ID: Subject: Re: ttl problem, cells are not deleted To: user Content-Type: multipart/alternative; boundary=001a1133f780d12d390502197e68 X-Virus-Checked: Checked by ClamAV on apache.org --001a1133f780d12d390502197e68 Content-Type: text/plain; charset=UTF-8 Is it a big table? A test cluster? Can you try to compact the table? 2014-09-02 14:40 GMT-04:00 Serega Sheypak : > Hi, I'm trying to use HBase TTL feature > here is table DDL: > > hbase(main):004:0> describe 'item_to_item_similar_rec' > DESCRIPTION > ENABLED > > {NAME => 'my_table', FAMILIES => [{NAME => 'd', DATA_BLOCK_ENCODING => > 'NONE', BLOOMFILTER => 'ROWCOL', REPLI true > > CATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS > => '1', TTL => '172800', KEEP_DELETED_CELLS => 'fal > > se', BLOCKSIZE => '65536', IN_MEMORY => 'true', ENCODE_ON_DISK => 'true', > BLOCKCACHE => 'true'}]} > > 1 row(s) in 0.1730 seconds > > It has ttl set to 172800 seconds = 2 days. > I see a cells that are much older than two days: > > column=d:099, timestamp=1409049061509, value=\x01\ > current ts = 1409679511000 > > 1409679511000 - 1409049061509 = 630449491 > --001a1133f780d12d390502197e68--