Hbase命令实战

Hbase创建表shell操作:
查看 命令 Help:
hbase(main):001:0> create 'user3' ,'info','info1' --创建表 ‘user3’
hbase(main):002:0> describle 'user3' –查看表结构
hbase(main):005:0> put 'user3', '1' ,'info1:name','kangknag' --向表中插入数据
hbase(main):006:0> scan 'user3' --全表扫描
ROW COLUMN+CELL
1 column=info1:name, timestamp=1542462490357, value=kangknag
1 row(s) in 0.1700 seconds
hbase(main):007:0> put 'user3', '1' ,'info1:name','kangknag1' --修改表数据,把表’user3’中
0 row(s) in 0.0480 seconds

hbase(main):008:0> scan 'user3'
ROW COLUMN+CELL
1 column=info1:name, timestamp=1542462600847, value=kangknag1
hbase(main):012:0> scan 'user3'
ROW COLUMN+CELL
1 column=info1:name, timestamp=1542462600847, value=kangknag1
12 column=info:name, timestamp=1542462773224, value=kangknag1
12 column=info1:name, timestamp=1542462687598, value=kangknag1
2 row(s) in 0.0710 seconds
--表的数据行数是根据 count(distinct(row))来计算的
hbase(main):013:0> count 'user3'
3 row(s) in 0.0890 seconds

hbase(main):015:0> get 'user3','12' --根据表明 rowid来查询
COLUMN CELL
info:name timestamp=1542462773224, value=kangknag1
info1:name timestamp=1542462687598, value=kangknag1

hbase(main):017:0> get 'user3','12','info' --根据列族名来查询
COLUMN CELL
info:name timestamp=1542462773224, value=kangknag1
1 row(s) in 0.0340 seconds

hbase(main):016:0> get 'user3','12','info:name' -- 根据列族 中的列来查询
COLUMN CELL
info:name timestamp=1542462773224, value=kangknag1
1 row(s) in 0.0400 seconds

hbase(main):020:0> deleteall 'user3', '12' --删除rowid 为12的数据
0 row(s) in 0.2040 seconds
hbase(main):022:0> truncate 'user3' --清空表的数据
Truncating 'user3' table (it may take a while):
- Disabling table...
- Truncating table...
0 row(s) in 4.9940 seconds

hbase(main):023:0> scan 'user3'
ROW COLUMN+CELL