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 <[email protected]> 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 <[email protected]> > To: [email protected]; [email protected] > 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 <[email protected] > >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 <[email protected]> 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 <[email protected] > >> >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 > >> > > >> > > > > >
