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



