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表结构
侵删!