Home | About | Sematext search-lucene.com search-hadoop.com
 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
Lars George 2011-07-18, 06:22
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: