Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: 
 <CABNOTEW4Dnn2hQMQe3R7G6Rfs3R54Lng8x_stfrcCwB1GWqDkQ@mail.gmail.com>
References: 
 <CABNOTEX9Bo1qJeCW6NiZxqM2oLXd=3U+Gs3fBVSEhWaeN+eXqA@mail.gmail.com>
 <1409684588.53370.YahooMailNeo@web140601.mail.bf1.yahoo.com>
 <CABNOTEW4Dnn2hQMQe3R7G6Rfs3R54Lng8x_stfrcCwB1GWqDkQ@mail.gmail.com>
From: Jean-Marc Spaggiari <jean-marc@spaggiari.org>
Date: Tue, 2 Sep 2014 15:16:05 -0400
Message-ID: 
 <CAPQV63Wv_o0iT+-M_KWsAhfxBC7hKPn5bT3v7jbv4ytGJF9wQw@mail.gmail.com>
Subject: Re: ttl problem, cells are not deleted
To: user <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=089e013a1e92b8e3a9050219f4cb

--089e013a1e92b8e3a9050219f4cb
Content-Type: text/plain; charset=UTF-8

No. The oposite. You will need to setup MIN_VERSIONS to 0 if you don't want
to keep any version if older than 2 days.


2014-09-02 15:13 GMT-04:00 Serega Sheypak <serega.sheypak@gmail.com>:

> Thanks :) So if I set MIN_VERSIONS>1, then TTL feature would completely
> remove experied row?
> My Idea is to automatically remove experied data. It's ok to see sometimes
> expired data but not more than for +-2 days (TTL-1 second + 1 day waiting
> for next major compation).
>
>
> 2014-09-02 23:03 GMT+04:00 lars hofhansl <larsh@apache.org>:
>
> > Are these the last versions of a cell? You have MIN_VERSIONS set to 1,
> > meaning HBase will keep at least one version around regardless of whether
> > it is expired by TTL or not.
> >
> > -- Lars
> >
> >
> >
> > ________________________________
> >  From: Serega Sheypak <serega.sheypak@gmail.com>
> > To: user <user@hbase.apache.org>
> > Sent: Tuesday, September 2, 2014 11:40 AM
> > Subject: ttl problem, cells are not deleted
> >
> >
> > 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
> >
>

--089e013a1e92b8e3a9050219f4cb--