hbase 常用命令

查看有哪些表

hbase(main):030:0> list
TABLE                                                                                                                                                                                          
mytable                                                                                                                                                                                        
t_users                                                                                                                                                                                        
test                                                                                                                                                                                           
3 row(s) in 0.0160 seconds

=> ["mytable", "t_users", "test"]

创建表

# 语法：create <table>, {NAME => <family>, VERSIONS => <VERSIONS>}
#或者 create <table>,<列>

hbase(main):024:0> create 't_users','info'
0 row(s) in 1.2600 seconds

=> Hbase::Table - t_users

查看表结构

hbase(main):028:0> describe 't_users'
Table t_users is ENABLED                                                                                                                                                                       
t_users                                                                                                                                                                                        
COLUMN FAMILIES DESCRIPTION                                                                                                                                                                    
{NAME => 'info', DATA_BLOCK_ENCODING => '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'}                                                                                                               
1 row(s) in 0.0440 seconds

修改表结构

#修改表结构必须先disable

# 语法：alter 't1', {NAME => 'f1'}, {NAME => 'f2', METHOD => 'delete'}
# 例如：修改表test1的cf的TTL为180天
hbase(main)> disable 'test1'
hbase(main)> alter 'test1',{NAME=>'body',TTL=>'15552000'},{NAME=>'meta', TTL=>'15552000'}
hbase(main)> enable 'test1'

删除表

#分两步：首先disable，然后drop
hbase(main)> disable 'tableName'
hbase(main)> drop 'tableName'

添加数据

#put
# 语法：put <table>,<rowkey>,<family:column>,<value>
hbase(main):010:0> put 'mytable','first','cf:message','hello' 
0 row(s) in 0.0610 seconds

查询数据

# 语法：get <table>,<rowkey>,[<family:column>,....]

hbase(main):021:0> get 'mytable','last' 
COLUMN                                           CELL                                                                                                                                          
 cf:_version                                     timestamp=1492179089588, value=1.1                                                                                                            
 cf:message                                      timestamp=1492178911594, value=xuyw                                                                                                           
2 row(s) in 0.0330 seconds

扫描表

# 语法：scan <table>, {COLUMNS => [ <family:column>,.... ], LIMIT => num}
# 例如：扫描表test的前4条数据
hbase(main)> scan 'test',{LIMIT=>4}

查询表中的数据行数

# 语法：count <table>, {INTERVAL => intervalNum, CACHE => cacheNum}

删除行中的某个列值（删除整行，无需列名）

# 语法：delete <table>, <rowkey>,  <family:column> , 必须指定列名

hbase(main)> delete 'test','last','cf:msg'

删除表中的所有数据

# 语法： truncate <table>