HBase命令

hbase(main):009:0> create_namespace 'bigdata'
Took 0.1211 seconds                                                                                               
hbase(main):010:0> create 'bigdata:student','baseinfo','schoolinfo'
Created table bigdata:student
Took 2.1646 seconds                                                                                               
=> Hbase::Table - bigdata:student
hbase(main):011:0> list_namespace_tables 'bigdata'
TABLE                                                                                                             
student                                                                                                           
1 row(s)
Took 0.0150 seconds                                                                                               
=> ["student"]
hbase(main):012:0> desc 'bigdata:student'
Table bigdata:student is ENABLED                                                                                  
bigdata:student                                                                                                   
COLUMN FAMILIES DESCRIPTION                                                                                       
{NAME => 'baseinfo', BLOOMFILTER => 'ROW', IN_MEMORY => 'false', VERSIONS => '1', KEEP_DELETED_CELLS => 'FALSE', D
ATA_BLOCK_ENCODING => 'NONE', COMPRESSION => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', BLOCKCACHE => 'true', 
BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'}                                                                   

{NAME => 'schoolinfo', BLOOMFILTER => 'ROW', IN_MEMORY => 'false', VERSIONS => '1', KEEP_DELETED_CELLS => 'FALSE',
 DATA_BLOCK_ENCODING => 'NONE', COMPRESSION => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', BLOCKCACHE => 'true'
, BLOCKSIZE => '65536', REPLICATION_SCOPE => '0'}                                                                 

2 row(s)
Quota is disabled
Took 0.0862 seconds                                     

查看表结构

hbase(main):012:0> desc 'bigdata:student'

禁用表

disable 'bigdata:student'

启用表

hbase(main):019:0> enable 'bigdata:student'

是否可用

hbase(main):017:0> is_enabled 'bigdata:student'

是否禁用

hbase(main):017:0> is_disabled 'bigdata:student'

删除表

hbase(main):021:0> drop 'bigdata:student'

需要先禁用表，否则报错

列族

新增列族

hbase(main):026:0> alter 'bigdata:student','teacherinfo'

删除列族

hbase(main):031:0> alter 'bigdata:student',{NAME=>'teacherinfo',METHOD=>'delete'}

添加列族数据

hbase(main):001:0> put 'bigdata:student','rowkey1','baseinfo:name','tom'

查看列族数据

hbase(main):002:0> get 'bigdata:student','rowkey1'

根据条件查询

hbase(main):001:0> get 'bigdata:student','rowkey2','baseinfo:name'

修改列族数据

hbase(main):018:0> put 'bigdata:student','rowkey2','baseinfo:name','jerriy'

删除指定列族下的指定列

delete 'bigdata:student','rowkey3','baseinfo:age'

删除指定行

deleteall 'bigdata:student','rowkey3'

更改列族存储版本的限制

hbase(main):003:0> alter 'bigdata:student',{NAME=>'baseinfo',VERSIONS=>3}

全表扫描(慎用，消耗资源)

hbase(main):020:0> scan 'bigdata:student'

扫描指定列族

hbase(main):003:0> scan 'bigdata:student', COLUMN=>'baseinfo'

全表扫描指定列族指定列

scan 'bigdata:student', COLUMN=>'baseinfo:birthday'

扫描指定起始行至结束行(不包含)

scan 'bigdata:student',{COLUMNS=>'baseinfo:name', STARTROW=>'rowkey1', STOPROW=>'rowkey4'}

scan 'bigdata:student',{COLUMNS=>'baseinfo:name', STARTROW=>'rowkey1', STOPROW=>'rowkey4', LIMIT=>3}
scan 'bigdata:student',{COLUMNS=>'baseinfo:name', STARTROW=>'rowkey1', STOPROW=>'rowkey4', LIMIT=>3,VERSIONS=>3}

值包含nt

scan 'bigdata:student',FILTER=>"ValueFilter(=,'substring:bdqn')"

值=24

scan 'bigdata:student',FILTER=>"ValueFilter(=,'binary:24')"

列以birth开头的

scan 'bigdata:student',FILTER=>"ColumnPrefixFilter('birth')"

以birth开头，且 值中包含2022

scan 'bigdata:student', FILTER=>"ColumnPrefixFilter('birth') AND ValueFilter(=,'substring:2022')"

扫描指定字段

hbase(main):007:0> scan 'bigdata:student',FILTER=>"ValueFilter(=,'substring:tom')"