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 >> unable to delete rows in some regions


Copy link to this message
-
unable to delete rows in some regions
Hey All, I was wondering if anyone had this issue with 0.90.5 HBASE.
I have a table 'img611', I issue delete of keys like this:

hbase(main):004:0> describe 'img611'
DESCRIPTION
                                                         ENABLED
 {NAME => 'img611', FAMILIES => [{NAME => 'att', BLOOMFILTER => 'ROW',
VERSIONS => '1', COMPRESSION => 'NONE', TTL => '21474836 true
 47', BLOCKSIZE => '350000', IN_MEMORY => 'false', BLOCKCACHE =>
'true'}]}
1 row(s) in 3.3440 seconds

hbase(main):003:0> delete 'img611', '611:u4rpx.jpg', 'att:data'
0 row(s) in 0.0210 seconds
hbase(main):005:0> major_compact 'img611'

After compaction completed on a region, the cells are still there,
even tho I am unable to 'get' them anymore.

hbase(main):005:0> get 'img611', '611:u4rpx.jpg'
COLUMN                                             CELL
0 row(s) in 0.0140 seconds

Here is compaction log:

2014-04-22 10:19:38,266 INFO
org.apache.hadoop.hbase.regionserver.Store: Completed major compaction
of 1 file(s), new
file=hdfs://namenode-rd.imageshack.us:9000/hbase/img611/cf0a557ff4030c238fc5a6ad732be45f/att/8509526122540116685,
size=17.7g; total size for store is 17.7g
2014-04-22 10:19:38,266 INFO
org.apache.hadoop.hbase.regionserver.HRegion: completed compaction on
region img611,u4rpx.jpg,1329700235569.cf0a557ff4030c238fc5a6ad732be45f.
after 35mins, 45sec

More here:  https://gist.github.com/anonymous/11187852

The store size was 17.7g, and remained the same after compaction. If I
examine hfile I can still see 611:u4rpx.jpg data in it.

Any ideas whats going on?

-Jack

 
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