Hbase访问之shell命令

Hbase访问之Shell基本操作

1.查看状态status

hbase(main):001:0> status
1 servers, 0 dead, 2.0000 average load

有一个服务器，0个挂掉的，2.0000的负荷

2.查看版本信息 version

hbase(main):002:0> version
0.98.3-hadoop1, rd5e65a9144e315bb0a964e7730871af32f5018d5, Sat May 31 19:34:57 PDT 2014

3.创建表和列族

create 'member','member_id','address','info'

member表名    后面三个是列族

4.查看表

hbase(main):004:0> list

5.查看表结构

hbase(main):006:0> describe "member"
DESCRIPTION                                          ENABLED                    
 'member', {NAME => 'address', DATA_BLOCK_ENCODING = true                       
 > 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE =                            
 > '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_                            
 VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CEL                            
 LS => 'false', BLOCKSIZE => '65536', IN_MEMORY => '                            
 false', BLOCKCACHE => 'true'}, {NAME => 'info', DAT                            
 A_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', R                            
 EPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSI                            
 ON => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER'                            
 , KEEP_DELETED_CELLS => 'false', BLOCKSIZE => '6553                            
 6', IN_MEMORY => 'false', BLOCKCACHE => 'true'}, {N                            
 AME => 'member_id', DATA_BLOCK_ENCODING => 'NONE',                             
 BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VER                            
 SIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS =                            
 > '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'fal                            
 se', BLOCKSIZE => '65536', IN_MEMORY => 'false', BL                            
 OCKCACHE => 'true'}                                                            
1 row(s) in 0.2210 seconds

6.删除列族

alter "member",{NAME=>"member_id",METHOD=>"delete"}

hbase(main):002:0> alter "member",{NAME=>"member_id",METHOD=>"delete"}
Updating all regions with the new schema...
0/1 regions updated.
1/1 regions updated.
Done.
0 row(s) in 5.5790 seconds

7.启用禁用表

hbase(main):004:0> disable "member"
0 row(s) in 1.5260 seconds

hbase(main):005:0> enable "member"
0 row(s) in 0.9940 seconds

8.删除表

hbase(main):014:0> disable "temp_table"
0 row(s) in 1.9400 seconds

hbase(main):015:0> drop "temp_table"
0 row(s) in 0.7270 seconds

hbase(main):016:0> list
TABLE                                                                           
member                                                                          
1 row(s) in 0.0540 seconds

=> ["member"]

9.检测表是否存在

hbase(main):017:0> exists "member"
Table member does exist                                                         
0 row(s) in 0.1100 seconds

hbase(main):018:0> exists "temp_table"
Table temp_table does not exist                                                 
0 row(s) in 0.1080 seconds

10.判断表是否启用

hbase(main):020:0> is_enabled "member"
true                                                                            
0 row(s) in 0.1070 seconds

hbase(main):021:0> is_disabled "member"
false                                                                           
0 row(s) in 0.1520 seconds

11.插入数据

 put "member","scutshuxue","info:birthday","1990-09-23"

put  表名，行建，列族:列   值

12.查询数据

hbase(main):028:0> get "member","scutshuxue"
COLUMN                CELL                                                      
 info:age             timestamp=1406787957904, value=18                         
 info:birthday        timestamp=1406788205924, value=1990-09-23                 
2 row(s) in 0.0250 seconds

获取表member   行建是scutshuxue的所有数据

hbase(main):029:0> get "member","scutshuxue","info"
COLUMN                CELL                                                      
 info:age             timestamp=1406787957904, value=18                         
 info:birthday        timestamp=1406788205924, value=1990-09-23                 
2 row(s) in 0.0190 seconds

获取表member  行建是scutshuxue列族是info的所有数据

hbase(main):030:0> get "member","scutshuxue","info:age"
COLUMN                CELL                                                      
 info:age             timestamp=1406787957904, value=18                         
1 row(s) in 0.0190 seconds

获取表member  行建是scutshuxue列族是info列是age的数据

hbase(main):002:0> get "member","scutshuxue",{COLUMN=>"info:age",TIMESTAMP=>1406787957904}
COLUMN                CELL                                                      
 info:age             timestamp=1406787957904, value=18                         
1 row(s) in 0.6080 seconds

根据时间搓来查询数据

hbase(main):006:0> count "member"
1 row(s) in 0.1040 seconds

查询表中有多少行

13.删除

hbase(main):007:0> delete "member","scutshuxue","info:birthday"
0 row(s) in 0.1860 seconds

hbase(main):008:0> scan "member"
ROW                   COLUMN+CELL                                                  
 scutshuxue           column=info:age, timestamp=1406788491458, value=20           
1 row(s) in 0.0340 seconds

删除表member   行scutshuxue  中列族info  的birthday字段

hbase(main):010:0> deleteall "member","scutshuxue"

删除整行

hbase(main):010:0> truncate "member"

清空表