HBase Shell

Base Shell命令总结

 

命令：create 'tableName','column' --创建表，并添加列族

命令：put 'tableName','rowName','column:key','value' --添加数据

命令：disable 'tableName' --disable表。注：修改表结构时，必须要先disable表。

命令：enable 'tableName' --使表可用

命令：drop 'tableName' --删除表

 

命令：list --查看所有表

hbase(main):016:0> list
TABLE                                                                          
tb                                                                             
1 row(s) in 0.0140 seconds

 

命令：scan 'table' --查看表数据

hbase(main):015:0> scan 'tb'
ROW                   COLUMN+CELL                                              
 yangzc               column=col:age, timestamp=1298606879036, value=123       
 yangzc               column=col:name, timestamp=1298606871385, value=yangzc   
1 row(s) in 0.0280 seconds

 

命令：get 'tableName','rowName' -- 检索行

hbase(main):017:0> get 'tb','yangzc'
COLUMN                CELL                                                     
 col:age              timestamp=1298606879036, value=123                       
 col:name             timestamp=1298606871385, value=yangzc                    
2 row(s) in 0.0530 seconds

 

命令：get 'tb','yangzc',{COLUMN=>['col']}  或者get 'tb','yangzc','col' --查看特定列

hbase(main):014:0> get 'tb','yangzc',{COLUMN=>['col']}
COLUMN                CELL                                                     
 col:age              timestamp=1298606879036, value=123                       
 col:name             timestamp=1298606871385, value=yangzc                    
2 row(s) in 0.0540 seconds

 

添加另外两天记录

命令：put 'tb','jiajia','col:age','12'

命令：put 'tb','jiajia','col:name','jiajia'

命令：scan 'tb'

hbase(main):009:0> scan 'tb'
ROW                                                      COLUMN+CELL                                                                                                                                                          
 jiajia                                                   column=col:age, timestamp=1298607640922, value=12                                                                                                                    
 jiajia                                                   column=col:name, timestamp=1298607664823, value=jiajia                                                                                                               
 yangzc                                                   column=col:age, timestamp=1298606879036, value=123                                                                                                                   
 yangzc                                                   column=col:name, timestamp=1298606871385, value=yangzc                                                                                                               
2 row(s) in 0.0520 seconds

 

执行命令：scan 'tb',{COLUMNS=>['col:age']}

hbase(main):018:0> scan 'tb',{COLUMNS=>['col:age']}
ROW                                                       COLUMN+CELL                                                                                                                                                          
 jiajia                                                   column=col:age, timestamp=1298607640922, value=12                                                                                                                    
 yangzc                                                   column=col:age, timestamp=1298606879036, value=123                                                                                                                   
2 row(s) in 0.0660 seconds