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:
> Try with STARTROW => "testtable2,,"?
> I seem to remember some weirdness about the start/stop row having to have
> the meta "format" with commas, etc
>
> -Todd
>
> On Fri, Jul 15, 2011 at 2:01 PM, Stack <[email protected]> wrote:
>
>> On Fri, Jul 15, 2011 at 11:40 AM, Lars George <[email protected]>
>> wrote:
>>> Using the start row, it prints the entire META.
>>
>> Starting with the STARTROW.
>>
>>> Setting a stop row it does
>>> not print a single row:
>>
>>
>> Yeah. I see that too in 0.90.3.
>>
>> St.Ack
>>
>>>
>>> hbase(main):003:0> scan '.META.', { STARTROW => 'testtable2', STOPROW =>
>>> 'testtable3' }
>>> ROW COLUMN+CELL
>>>
>>> 0 row(s) in 0.0220 seconds
>>>
>>> I have a testtable2 in this case. Am I stuffing up the syntax?
>>>
>>> Lars
>>>
>>> On Fri, Jul 15, 2011 at 8:36 PM, Stack <[email protected]> wrote:
>>>
>>>> Passing 'STARTROW' in 0.90.3 seems to work. What you see Lars?
>>>> St.Ack
>>>>
>>>> On Fri, Jul 15, 2011 at 11:31 AM, Lars George <[email protected]>
>>>> wrote:
>>>>> Hi,
>>>>>
>>>>> I am on 0.90.1 (CDH3u0) but noticed that on trunk as well: doing scan
>> of
>>>>> .META. using a start and stop row does not work. The start row does
>>>> nothing,
>>>>> i.e. all is shown, and setting the stop row is the opposite, i.e.
>> nothing
>>>> is
>>>>> shown. Is that borked?
>>>>>
>>>>> Lars
>>>>>
>>>>
>>>
>>
>
>
>
> --
> Todd Lipcon
> Software Engineer, Cloudera
