hbase shell命令

1. hbase 基本命令

• hbase shell # 进入hbase

• help # 进入hbase后台，查看帮助信息

• status # 查看hbase集群状态

• version # 查看数据库版本

• list # 查看数据库中所有的表

• describe 'tablename' # 查看表的详细信息

2. 其他命令

2.1创建表StudentAndCourse，列簇为student、course1，course2、course3

create "StudentAndCourse", "student", "course1", "course2", "course3"
​
运行结果：
hbase:002:0> create "StudentAndCourse", "student", "course1", "course2", "course3"
Created table StudentAndCourse
Took 1.1680 seconds                                                                                                                                                                                                             
=> Hbase::Table - StudentAndCourse

查看表:

hbase:004:0> describe "StudentAndCourse"
Table StudentAndCourse is ENABLED
StudentAndCourse, {TABLE_ATTRIBUTES => {METADATA => {'hbase.store.file-tracker.impl' => 'DEFAULT'}}}
COLUMN FAMILIES DESCRIPTION
{NAME => 'course1', 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 B (64KB)', REPLICATION_SCOPE => '0'}
{NAME => 'course2', 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 B (64KB)', REPLICATION_SCOPE => '0'}
{NAME => 'course3', 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 B (64KB)', REPLICATION_SCOPE => '0'} 
{NAME => 'student', 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 B (64KB)', REPLICATION_SCOPE => '0'}
4 row(s)
Quota is disabled
Took 0.0958 seconds
​
​
说明：
Table StudentAndCourse is ENABLED # 表状态，表是激活的(可用的)
​
TABLE_ATTRIBUTES => {METADATA => {'hbase.store.file-tracker.impl' => 'DEFAULT'}} # 使用默认的命名空间default，注意是小写，因为hbase默认有两个命名空间，一个是内置的hbase命名空间，存放hbase内置表，另一个是default命名空间，用户默认使用的命名空间。
​
COLUMN FAMILIES DESCRIPTION # 列簇描述，如上有四个列簇，course1、course2、course3、student（NAME => 列簇名）

2.2 插入数据

新增学生信息
put 'StudentAndCourse' ,'2023003','student:S_Name','Lisi'
put 'StudentAndCourse' ,'2023003','student:S_Sex','male'
put 'StudentAndCourse' ,'2023003','student:S_Age','24'
put 'StudentAndCourse' ,'2023003','course1:C_No','123001'
put 'StudentAndCourse' ,'2023003','course1:C_Name','Math'
put 'StudentAndCourse' ,'2023003','course1:C_Credit','2.0'
put 'StudentAndCourse' ,'2023003','course1:Score','98'
put 'StudentAndCourse' ,'2023003','course2:C_No','123002'
put 'StudentAndCourse' ,'2023003','course2:C_Name','Computer Science'
put 'StudentAndCourse' ,'2023003','course2:C_Credit','5.0'
put 'StudentAndCourse' ,'2023003','course2:Score','95'
...
...

2.3 浏览数据

scan
​
2023003                                                  column=course2:C_No, timestamp=2023-06-06T11:31:37.375, value=123002                                                                                                  
 2023003                                                  column=course2:Score, timestamp=2023-06-06T11:31:38.057, value=95                                                                                                     
 2023003                                                  column=student:S_Age, timestamp=2023-06-06T11:31:37.310, value=24                                                                                                     
 2023003                                                  column=student:S_Name, timestamp=2023-06-06T11:31:37.279, value=Lisi                                                                                                  
 2023003                                                  column=student:S_Sex, timestamp=2023-06-06T11:31:37.298, value=male 

2.4 查看有哪些表

list
​
hbase:051:0> list
TABLE        
​
StudentAndCourse   
1 row(s)
Took 0.0167 seconds
=> ["StudentAndCourse"]
​
说明：默认为default命名空间

2.5 查看命名空间列表

list_namespace
​
hbase:049:0> list_namespace
NAMESPACE         
default        
hbase     
2 row(s)
​
第一个不是命名空间名称，是列名称-命名空间

2.6 查看命名空间下有哪些表

list_namespace_tables 'default'
TABLE                                                                                                                                          
StudentAndCourse 
1 row(s)

2.7 创建命名空间

create_namespace 'commerce'

• 删除命名空间

drop_namespace 'commerce'

• 使用创建的命名空间创建表

create 'commerce.province_city_info', 'provinceInfo', 'cityInfo'

2.8 删除表

删除表之前先停止表，
第一步：
disable 'commerce.province_city_info'
第二步:
drop 'commerce.province_city_info'

2.9 判断表是否存在

exists 'commerce.province_city_info'

2.10 新增列簇

alter 'commerce.province_city_info','otherInfo'

2.11 删除列簇

alter 'commerce.province_city_info','otherInfo',{NAME=>'otherInfo',METHOD=>'delete'}

2.12 设置列簇记录三个版本

alter 'commerce.province_city_info',{NAME=>'provinceInfo',VERSIONS=>3}

2.13 设置浏览列簇/cell

scan 'StudentAndCourse',{COLUMN=>'student'}
scan 'StudentAndCourse',{COLUMN=>'student:S_Name'}

2.14 删除指定列簇下的列

delete 'StudentAndCourse','2023003','student:S_Age'

2.15 删除指定的rowkey

deleteall 'StudentAndCourse', '2015001'