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 # dev >> Scanning .META. with start/stop row


Copy link to this message
-
Re: Scanning .META. with start/stop row
Wow, awesome Todd:

hbase(main):004:0> scan '.META.', {STARTROW => 'testtable2', LIMIT => 1}
ROW                                 COLUMN+CELL                                                                                          
2011-07-17T23:20:45.480-0700: 58.760: [GC 58.760: [ParNew: 19136K->2112K(19136K), 0.0098980 secs] 21990K->6759K(83008K), 0.0099430 secs] [Times: user=0.05 sys=0.00, real=0.01 secs]
 TestTable,,1294648777729.1c1644f4a column=info:regioninfo, timestamp=1294648777898, value=REGION => {NAME => 'TestTable,,1294648777729.1c
 1304442d9c8483a6d167d48.           1644f4a1304442d9c8483a6d167d48.', STARTKEY => '', ENDKEY => '', ENCODED => 1c1644f4a1304442d9c8483a6d1
                                    67d48, TABLE => {{NAME => 'TestTable', FAMILIES => [{NAME => 'col1', BLOOMFILTER => 'NONE', REPLICATIO
                                    N_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '65536', IN_
                                    MEMORY => 'false', BLOCKCACHE => 'true'}]}}                                                          
...
1 row(s) in 0.3990 seconds

hbase(main):005:0> scan '.META.', {STARTROW => 'testtable2,,', LIMIT => 1}
ROW                                 COLUMN+CELL                                                                                          
 testtable2,,1310754563673.d720f2ae column=info:regioninfo, timestamp=1310754573539, value=REGION => {NAME => 'testtable2,,1310754563673.d
 6a4aec4fce746f6a9c1376e3.          720f2ae6a4aec4fce746f6a9c1376e3.', STARTKEY => '', ENDKEY => 'row-10', ENCODED => d720f2ae6a4aec4fce74
                                    6f6a9c1376e3, TABLE => {{NAME => 'testtable2', FAMILIES => [{NAME => 'family', BLOOMFILTER => 'NONE',
                                    REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '6
                                    5536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}]}}                                                
...
1 row(s) in 0.0440 seconds

This also makes the STOPROW work:

hbase(main):006:0> scan '.META.', {STARTROW => 'testtable2,,', STOPROW => 'testtable3'}
ROW                                 COLUMN+CELL                                                                                          
0 row(s) in 0.0220 seconds

hbase(main):007:0> scan '.META.', {STARTROW => 'testtable2,,', STOPROW => 'testtable3,,'}
ROW                                 COLUMN+CELL                                                                                          
 testtable2,,1310754563673.d720f2ae column=info:regioninfo, timestamp=1310754573539, value=REGION => {NAME => 'testtable2,,1310754563673.d
 6a4aec4fce746f6a9c1376e3.          720f2ae6a4aec4fce746f6a9c1376e3.', STARTKEY => '', ENDKEY => 'row-10', ENCODED => d720f2ae6a4aec4fce74
                                    6f6a9c1376e3, TABLE => {{NAME => 'testtable2', FAMILIES => [{NAME => 'family', BLOOMFILTER => 'NONE',
                                    REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '3', TTL => '2147483647', BLOCKSIZE => '6
                                    5536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}]}}                                                
...
 testtable2,row-10,1310754563677.81 column=info:regioninfo, timestamp=1310754573667, value=REGION => {NAME => 'testtable2,row-10,131075456
 73e0623a0f82c5b308790737900b60.    3677.8173e0623a0f82c5b308790737900b60.', STARTKEY => 'row-10', ENDKEY => 'row-20', ENCODED => 8173e062
                                    3a0f82c5b308790737900b60, TABLE => {{NAME => 'testtable2', FAMILIES => [{NAME => 'family', BLOOMFILTER
                                     => 'NONE', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '3', TTL => '2147483647', BLO
                                    CKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}]}}                                    
...

So it is caused by the same issue. Should be fixed, right?

Lars
On Jul 18, 2011, at 4:36 AM, Todd Lipcon wrote:

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