hbase shell
hbase(main):003:0> create 'test', 'cf'
0 row(s) in 1.2200 seconds
hbase(main):003:0> list 'test'
..
1 row(s) in 0.0550 seconds
hbase(main):004:0> put 'test', 'row1', 'cf:a', 'value1'
0 row(s) in 0.0560 seconds
hbase(main):005:0> put 'test', 'row2', 'cf:b', 'value2'
0 row(s) in 0.0370 seconds
hbase(main):006:0> put 'test', 'row3', 'cf:c', 'value3'
0 row(s) in 0.0450 seconds
hbase(main):007:0> scan 'test'
ROW COLUMN+CELL
row1 column=cf:a, timestamp=1288380727188, value=value1
row2 column=cf:b, timestamp=1288380738440, value=value2
row3 column=cf:c, timestamp=1288380747365, value=value3
3 row(s) in 0.0590 seconds
Get a single row
hbase(main):008:0> get 'test', 'row1'
COLUMN CELL
cf:a timestamp=1288380727188, value=value1
1 row(s) in 0.0400 seconds
hbase(main):012:0> disable 'test'
0 row(s) in 1.0930 seconds
hbase(main):013:0> drop 'test'
0 row(s) in 0.0770 seconds
hbase(main):004:0* scan 'test', {COLUMNS => ['cf:a']}
ROW COLUMN+CELL
row1 column=cf:a, timestamp=1369307716818, value=value1
1 row(s) in 0.1230 seconds
hbase(main):005:0> scan 'test', {COLUMNS => 'cf:a', TIMERANGE => [1369307716900, 1369307716910]}
ROW COLUMN+CELL
row1 column=cf:a, timestamp=1369307716818, value=value1
1 row(s) in 0.0650 seconds
hbase(main):006:0> scan 'test', {COLUMNS => 'cf:a', TIMERANGE => [1369307716900, 1369307716910]}
ROW COLUMN+CELL
0 row(s) in 0.0260 seconds
hbase(main):004:0> count 'test'
2 row(s) in 0.0070 seconds
hbase(main):007:0> create 't1', {NAME => 'f1'}, {NAME => 'f2'}, {NAME => 'f3'}
0 row(s) in 1.3320 seconds
=> Hbase::Table - t1
hbase(main):013:0> put 't1', 'r1', 'f1', 'value'
0 row(s) in 0.0600 seconds
hbase(main):014:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
1 row(s) in 0.0180 seconds
hbase(main):015:0> put 't1', 'r1', 'f1:a', 'value'
0 row(s) in 0.0070 seconds
hbase(main):016:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
1 row(s) in 0.0120 seconds
hbase(main):017:0> put 't1', 'r1', 'f1:b', 'value'
0 row(s) in 0.0060 seconds
hbase(main):018:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310565203, value=value
1 row(s) in 0.0140 seconds
hbase(main):020:0> put 't1', 'r1', 'f2', 'value'
0 row(s) in 0.0150 seconds
hbase(main):021:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310565203, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0150 seconds
hbase(main):022:0> put 't1', 'r1', 'f1:b', 'value'
0 row(s) in 0.0240 seconds
hbase(main):023:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0150 seconds
hbase(main):025:0> scan 't1', {COLUMNS => ['f1:a']}
ROW COLUMN+CELL
r1 column=f1:a, timestamp=1369310547264, value=value
1 row(s) in 0.0250 seconds
hbase(main):026:0> scan 't1', {COLUMNS => ['f1:']}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
1 row(s) in 0.0340 seconds
hbase(main):027:0> scan 't1', {COLUMNS => ['f1']}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
1 row(s) in 0.0090 seconds
scan 't1', {COLUMNS => ['f1', 'f2'], LIMIT => 10, \
STARTROW => 'r1'}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0170 seconds
hbase(main):033:0> scan 't1', {COLUMNS => ['f1', 'f2'], LIMIT => 10, STARTROW => 'r1'}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0170 seconds
hbase(main):039:0> status
4 servers, 0 dead, 1.0000 average load
hbase(main):040:0> status 'simple'
4 live servers
hadoop-yarn2.mydomain.com:60020 1369297397823
requestsPerSecond=0, numberOfOnlineRegions=2, usedHeapMB=39, maxHeapMB=287
hadoop-yarn3.mydomain.com:60020 1369297396938
requestsPerSecond=0, numberOfOnlineRegions=0, usedHeapMB=25, maxHeapMB=287
hadoop-yarn4.mydomain.com:60020 1369297397877
requestsPerSecond=0, numberOfOnlineRegions=1, usedHeapMB=41, maxHeapMB=287
hadoop-yarn1.mydomain.com:60020 1369297417598
requestsPerSecond=0, numberOfOnlineRegions=1, usedHeapMB=40, maxHeapMB=97
0 dead servers
Aggregate load: 0, regions: 4
create 't2', 'cf2', \
{ SPLITS => ['row-300', 'row-500', 'row-700' , 'row-900'] }
hbase(main):010:0> for i in '0'..'9' do \
for j in '0'..'9' do \
for k in '0'..'9' do \
put 't2', "row-#{i}#{j}#{k}", \
"cf2:#{j}#{k}", "#{j}#{k}" \
end end end
hbase(main):019:0> count 't2'
Current count: 1000, row: row-999
1000 row(s) in 0.4310 seconds
hbase(main):010:0> flush 't2'
hadoop dfs -lsr /hbase
hadoop dfs -cat /hbase/hbase.id
hadoop dfs -cat /hbase/hbase.version
hbase(main):010:0> for i in '0'..'1000000' do \
put 't2', "row-#{i}", \
"cf2:#{i}", "#{i}" \
end
hbase(main):003:0> create 'test', 'cf'
0 row(s) in 1.2200 seconds
hbase(main):003:0> list 'test'
..
1 row(s) in 0.0550 seconds
hbase(main):004:0> put 'test', 'row1', 'cf:a', 'value1'
0 row(s) in 0.0560 seconds
hbase(main):005:0> put 'test', 'row2', 'cf:b', 'value2'
0 row(s) in 0.0370 seconds
hbase(main):006:0> put 'test', 'row3', 'cf:c', 'value3'
0 row(s) in 0.0450 seconds
hbase(main):007:0> scan 'test'
ROW COLUMN+CELL
row1 column=cf:a, timestamp=1288380727188, value=value1
row2 column=cf:b, timestamp=1288380738440, value=value2
row3 column=cf:c, timestamp=1288380747365, value=value3
3 row(s) in 0.0590 seconds
Get a single row
hbase(main):008:0> get 'test', 'row1'
COLUMN CELL
cf:a timestamp=1288380727188, value=value1
1 row(s) in 0.0400 seconds
hbase(main):012:0> disable 'test'
0 row(s) in 1.0930 seconds
hbase(main):013:0> drop 'test'
0 row(s) in 0.0770 seconds
hbase(main):004:0* scan 'test', {COLUMNS => ['cf:a']}
ROW COLUMN+CELL
row1 column=cf:a, timestamp=1369307716818, value=value1
1 row(s) in 0.1230 seconds
hbase(main):005:0> scan 'test', {COLUMNS => 'cf:a', TIMERANGE => [1369307716900, 1369307716910]}
ROW COLUMN+CELL
row1 column=cf:a, timestamp=1369307716818, value=value1
1 row(s) in 0.0650 seconds
hbase(main):006:0> scan 'test', {COLUMNS => 'cf:a', TIMERANGE => [1369307716900, 1369307716910]}
ROW COLUMN+CELL
0 row(s) in 0.0260 seconds
hbase(main):004:0> count 'test'
2 row(s) in 0.0070 seconds
hbase(main):007:0> create 't1', {NAME => 'f1'}, {NAME => 'f2'}, {NAME => 'f3'}
0 row(s) in 1.3320 seconds
=> Hbase::Table - t1
hbase(main):013:0> put 't1', 'r1', 'f1', 'value'
0 row(s) in 0.0600 seconds
hbase(main):014:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
1 row(s) in 0.0180 seconds
hbase(main):015:0> put 't1', 'r1', 'f1:a', 'value'
0 row(s) in 0.0070 seconds
hbase(main):016:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
1 row(s) in 0.0120 seconds
hbase(main):017:0> put 't1', 'r1', 'f1:b', 'value'
0 row(s) in 0.0060 seconds
hbase(main):018:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310565203, value=value
1 row(s) in 0.0140 seconds
hbase(main):020:0> put 't1', 'r1', 'f2', 'value'
0 row(s) in 0.0150 seconds
hbase(main):021:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310565203, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0150 seconds
hbase(main):022:0> put 't1', 'r1', 'f1:b', 'value'
0 row(s) in 0.0240 seconds
hbase(main):023:0> scan 't1'
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0150 seconds
hbase(main):025:0> scan 't1', {COLUMNS => ['f1:a']}
ROW COLUMN+CELL
r1 column=f1:a, timestamp=1369310547264, value=value
1 row(s) in 0.0250 seconds
hbase(main):026:0> scan 't1', {COLUMNS => ['f1:']}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
1 row(s) in 0.0340 seconds
hbase(main):027:0> scan 't1', {COLUMNS => ['f1']}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
1 row(s) in 0.0090 seconds
scan 't1', {COLUMNS => ['f1', 'f2'], LIMIT => 10, \
STARTROW => 'r1'}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0170 seconds
hbase(main):033:0> scan 't1', {COLUMNS => ['f1', 'f2'], LIMIT => 10, STARTROW => 'r1'}
ROW COLUMN+CELL
r1 column=f1:, timestamp=1369310510758, value=value
r1 column=f1:a, timestamp=1369310547264, value=value
r1 column=f1:b, timestamp=1369310610728, value=value
r1 column=f2:, timestamp=1369310595376, value=value
1 row(s) in 0.0170 seconds
hbase(main):039:0> status
4 servers, 0 dead, 1.0000 average load
hbase(main):040:0> status 'simple'
4 live servers
hadoop-yarn2.mydomain.com:60020 1369297397823
requestsPerSecond=0, numberOfOnlineRegions=2, usedHeapMB=39, maxHeapMB=287
hadoop-yarn3.mydomain.com:60020 1369297396938
requestsPerSecond=0, numberOfOnlineRegions=0, usedHeapMB=25, maxHeapMB=287
hadoop-yarn4.mydomain.com:60020 1369297397877
requestsPerSecond=0, numberOfOnlineRegions=1, usedHeapMB=41, maxHeapMB=287
hadoop-yarn1.mydomain.com:60020 1369297417598
requestsPerSecond=0, numberOfOnlineRegions=1, usedHeapMB=40, maxHeapMB=97
0 dead servers
Aggregate load: 0, regions: 4
create 't2', 'cf2', \
{ SPLITS => ['row-300', 'row-500', 'row-700' , 'row-900'] }
hbase(main):010:0> for i in '0'..'9' do \
for j in '0'..'9' do \
for k in '0'..'9' do \
put 't2', "row-#{i}#{j}#{k}", \
"cf2:#{j}#{k}", "#{j}#{k}" \
end end end
hbase(main):019:0> count 't2'
Current count: 1000, row: row-999
1000 row(s) in 0.4310 seconds
hbase(main):010:0> flush 't2'
hadoop dfs -lsr /hbase
hadoop dfs -cat /hbase/hbase.id
hadoop dfs -cat /hbase/hbase.version
hbase(main):010:0> for i in '0'..'1000000' do \
put 't2', "row-#{i}", \
"cf2:#{i}", "#{i}" \
end
Comments
Post a Comment