Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> Using TTL tout purge data automatically ?


Copy link to this message
-
Using TTL tout purge data automatically ?
Hello,

I created yesterday an HTable with 2 CF specifying the TTL for 5 an 10
min respectively.

Inserted 2 datas (one in each column)

And hoped that my values desapear passed a certain amount of time.

This never happend ...

This morning I keep hope that major_compaction once a days withdraw my
expired datas ...

Disapointed :

hbase(main):004:0> describe 'ttltest'
DESCRIPTION                                                                                                                          
ENABLED
  {NAME => 'ttltest', FAMILIES => [{NAME => 'longttl', BLOOMFILTER =>
'NONE', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSION true
  S => '1', TTL => '600000', BLOCKSIZE => '65536', IN_MEMORY => 'false',
BLOCKCACHE => 'true'}, {NAME => 'shortttl', BLOOMFILTER => 'N
  ONE', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS =>
'1', TTL => '300000', BLOCKSIZE => '65536', IN_MEMORY => 'false',
   BLOCKCACHE => 'true'}]}

hbase(main):005:0> scan 'ttltest'
ROW                                                  COLUMN+CELL
  test1                                              
column=longttl:data, timestamp=1316697813182, value=jeudi 22 septembre
2011, 15:22:06 (UTC+0200)
  test1                                              
column=shortttl:data, timestamp=1316697803522, value=jeudi 22 septembre
2011, 15:22:06 (UTC+0200)
1 row(s) in 0.1280 seconds
Is TTL usable to purge expired values (even the last ones) ?

Best regards,

--
Damien
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB