Mailing-List: contact dev-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of yuzhihong@gmail.com designates
 209.85.217.177 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1365044851.91652.YahooMailNeo@web140605.mail.bf1.yahoo.com>
References: 
 <CANsfGRk2DihjL9-OZiGrcYt2_TdGjxWU01ev5MjHob376M8Phw@mail.gmail.com>
	<CALte62ytCRg+-cdKERWHw4qsgQKkrRSc9ztV8n6T70jwOs=aJg@mail.gmail.com>
	<CANsfGR=o8CYN+0FQMG5eE1f8LqHQ1B1Uz-mwz7PNmsMjn6Rj7Q@mail.gmail.com>
	<CANsfGRm_D0sKR5wLbEgLs0xhUVCrPHOgRmfdME9Pvu+QK4sLOg@mail.gmail.com>
	<1365044851.91652.YahooMailNeo@web140605.mail.bf1.yahoo.com>
Date: Wed, 3 Apr 2013 20:52:23 -0700
Message-ID: 
 <CALte62wHyfGDvNRR66eFGpnUD9QOh=odFE-4+bHbsG4k0YWVTA@mail.gmail.com>
Subject: Re: HBase Column Family TTL and cell deletions
From: Ted Yu <yuzhihong@gmail.com>
To: "dev@hbase.apache.org" <dev@hbase.apache.org>,
 lars hofhansl <larsh@apache.org>
Content-Type: multipart/alternative; boundary=089e012292faf5bd5e04d980e588

--089e012292faf5bd5e04d980e588
Content-Type: text/plain; charset=ISO-8859-1

I used http://www.ruddwire.com/handy-code/date-to-millisecond-calculators/and
got same result.

I think the initial confusion was due to TTL being in seconds and timestamp
being in milliseconds.


On Wed, Apr 3, 2013 at 8:07 PM, lars hofhansl <larsh@apache.org> wrote:

> 1364928886015 is Tue Apr 02 11:54:46 PDT 2013, no?
> So it's less than a day old.
>
> (Sorry if I am missing something)
>
>
> -- Lars
>
>
>
> ________________________________
>  From: Ashish Nigam <ashnigamtech@gmail.com>
> To: user@hbase.apache.org; dev@hbase.apache.org
> Sent: Wednesday, April 3, 2013 3:19 PM
> Subject: Re: HBase Column Family TTL and cell deletions
>
> Any thoughts?
>
> Here's one cell that should have been deleted ( I am putting HBase get
> repines in shell)
>
> hbase(main):001:0> get 'service_counters','3141',{COLUMN =>
> 'stats-hourly:2013032014-C-U-4092276'}
> 13/04/03 21:57:17 WARN util.NativeCodeLoader: Unable to load native-hadoop
> library for your platform... using builtin-java classes where applicable
> COLUMN                                                            CELL
>
>
>
>
> stats-hourly:2013032014-C-U-4092276
> timestamp=1364928886015, value=\x00\x00\x00\x00\x00\x00\x00\x06
>
>
>
> 1 row(s) in 0.1040 seconds
>
>
> On Wed, Apr 3, 2013 at 12:03 PM, Ashish Nigam <ashnigamtech@gmail.com
> >wrote:
>
> > minVersion is set to 0
> > Here's detailed info on this CF -
> >
> > {NAME => 'stats-hourly', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER =>
> > 'NONE', REPLICATION_SCOPE => '0', VERSIONS => '3', COMPRESSION => 'LZO',
> > MIN_VERSIONS => '0', TTL => '604800', KEEP_DELETED_CELLS => 'false',
> > BLOCKSIZE => '65536', IN_MEMORY => 'false', ENCODE_ON_DISK => 'true',
> > BLOCKCACHE => 'true'}
> >
> > HBase version is 0.94.2-cdh4.2.0,
> >
> >
> >
> > On Wed, Apr 3, 2013 at 11:48 AM, Ted Yu <yuzhihong@gmail.com> wrote:
> >
> >> Is it possible that minVersions was set for your column family ?
> >>
> >> What version of HBase are you using ?
> >>
> >> Thanks
> >>
> >>
> >> On Wed, Apr 3, 2013 at 11:34 AM, Ashish Nigam <ashnigamtech@gmail.com
> >> >wrote:
> >>
> >> > Hi,
> >> > I have a table "service_counters" that has service id as row id.
> >> > There is a column family "stats-hourly" that stores counters related
> to
> >> > that service per hour.
> >> > I have set TTL to be 7 days for the column family.
> >> >
> >> > {NAME => 'service_counters', FAMILIES => [{NAME => 'stats-hourly',
> >> > COMPRESSION => 'LZO', TTL => '604800'}]}
> >> >
> >> > Now the problem is that I still see columns that are more than 7 days
> >> old.
> >> > I have also run major compactions but I still see old rows.
> >> > Any pointers as to why these columns are not being deleted?
> >> >
> >> > Thanks
> >> > Ashish
> >> >
> >>
> >
> >
>

--089e012292faf5bd5e04d980e588--