初识hbase

1.hbase表结构如下：

RowKey：行键（类似于mysql中的主键） ColumnFamily：列簇 Column：列名

RowKey	ColumnFamily1		ColumnFamily1
	Column1	Column2	Column3	Column4	Column5
RowKey1	Value1	Value	Value	Value	Value
RowKey2	Value	Value	Value	Value	Value

2.hbase集群结构

3.hbase常用语句

• 查看所有表：list
• 建表，例如建立一张stu表，列簇为info

  create 'stu','info'

插入数据：

hbase(main):007:0> put 'stu','1001','info:sex','male'
Took 1.0000 seconds                                                                                                                                        
hbase(main):008:0> put 'stu','1001','info:age','18'
Took 0.4898 seconds                                                                                                                                        
hbase(main):009:0> put 'stu','1001','info:name','Janna'
Took 0.0845 seconds                                                                                                                                        
hbase(main):010:0> put 'stu','1002','info:sex','female'
Took 0.0226 seconds                                                                                                                                        
hbase(main):011:0> put 'stu','1002','info:age','20'
Took 0.0409 seconds 

查看数据：

hbase(main):012:0> scan 'stu'
ROW                                     COLUMN+CELL                                                                                                        
 1001                                   column=info:age, timestamp=1652704211907, value=18                                                                 
 1001                                   column=info:name, timestamp=1652704229025, value=Janna                                                             
 1001                                   column=info:sex, timestamp=1652703916312, value=male                                                               
 1002                                   column=info:age, timestamp=1652704274899, value=20                                                                 
 1002                                   column=info:sex, timestamp=1652704253295, value=female                                                             
2 row(s)
Took 3.4488 seconds  

修改数据：

put 'stu','1001','info:name','Anna'

查看某一行的所有数据 ：

hbase(main):007:0> get 'stu','1001'
COLUMN                                  CELL                                                                                                               
 info:age                               timestamp=1652704211907, value=18                                                                                  
 info:name                              timestamp=1652704902711, value=Anna                                                                                
 info:sex                               timestamp=1652703916312, value=male                                                                                
1 row(s)
Took 0.5296 seconds 

根据行键和列名查看数据：

hbase(main):008:0> get 'stu','1001','info:name'
COLUMN                                  CELL                                                                                                               
 info:name                              timestamp=1652704902711, value=Anna                                                                                
1 row(s)
Took 0.3037 seconds 

求有多少列：

hbase(main):010:0> count 'stu'
2 row(s)
Took 5.6065 seconds                                                                                                                                        
=> 2

根据行键和列名删除某项数据：

hbase(main):013:0> delete 'stu','1001','info:name'
Took 0.1497 seconds                                                                                                                                        
hbase(main):014:0> scan 'stu'
ROW                                     COLUMN+CELL                                                                                                        
 1001                                   column=info:age, timestamp=1652704211907, value=18                                                                 
 1001                                   column=info:sex, timestamp=1652703916312, value=male                                                               
 1002                                   column=info:age, timestamp=1652704274899, value=20                                                                 
 1002                                   column=info:name, timestamp=1652704950661, value=Jack                                                              
 1002                                   column=info:sex, timestamp=1652704253295, value=female                                                             
2 row(s)
Took 0.1834 seconds  

删除指定行所有数据：

hbase(main):017:0> deleteall 'stu','1001'
Took 0.0079 seconds  

 清空表中数据：

hbase(main):026:0> truncate 'stu'
Truncating 'stu' table (it may take a while):
Disabling table...
Truncating table...
Took 44.2310 seconds 

 disable并删除表

hbase(main):029:0> disable 'stu'
Took 1.6218 seconds                                                                                                                                        
hbase(main):030:0> is_enabled 'stu'
false                                                                                                                                                      
Took 0.1170 seconds                                                                                                                                        
=> false
hbase(main):031:0> drop 'stu'
Took 3.1445 seconds                                                                                                                                        
hbase(main):032:0> list
TABLE                                                                                                                                                      
0 row(s)
Took 0.0269 seconds                                                                                                                                        
=> []

 参考：HBase学习二：HBase的表结构_hucs420109的博客-CSDN博客_hbase表结构

 侵删！