基本操作
- 進(jìn)入HBase客戶(hù)端命令行
[hadoop@hadoop-100 hbase]$ cd bin/hbase shell - 查看幫助命令
hbase(main):001:0> help - 查看當(dāng)前數(shù)據(jù)庫(kù)中有哪些表
hbase(main):002:0> list
list命令查看的是用戶(hù)表
表的操作
- 創(chuàng)建表
hbase(main):003:0> create 'student','info'
student 是表名
info是列祖族名 - 插入數(shù)據(jù)到表
hbase(main):005:0> put 'student','1000','info:sex','male'
hbase(main):006:0> put 'student','1000','info:agx','18'
hbase(main):007:0> put 'student','1000','info:name','zj'
hbase(main):008:0> put 'student','1001','info:sex','female'
hbase(main):009:0> put 'student','1001','info:agx','18'
hbase(main):010:0> put 'student','1001','info:name','fxb'
解釋說(shuō)明
student 表名
1001敢订、1001 RowKey
info:agx 列族中的列key
zj心例、fxb 列族總的列value - 更新指定字段數(shù)據(jù)
hbase(main):031:0> put 'student','1000','info:name','zfh'
hbase(main):031:0> put 'student','1000','info:age','19' - 查看表數(shù)據(jù)
hbase(main):015:0> get 'student','1000'
查看student表见妒,rowkey為1000的數(shù)據(jù)
hbase(main):016:0> get 'student','1000','info'
查看student表疟赊,rowkey為1000的info列族數(shù)據(jù)
hbase(main):017:0> get 'student','1000','info:name'
查看student表郊供,rowkey為1000的info列族下name列的數(shù)據(jù) - 掃描查看表數(shù)據(jù)
hbase(main):018:0> scan 'student'
掃描student表
hbase(main):020:0> scan 'student',{STARTROW => '1000'}
掃描student表,帶開(kāi)始范圍
hbase(main):021:0> scan 'student',{STARTROW => '1000',STOPROW => '1000'}
掃描student表近哟,帶開(kāi)始范圍和結(jié)束范圍驮审,注意STARTROW 和STOPROW區(qū)分大小寫(xiě) - 刪除數(shù)據(jù)
hbase(main):025:0> delete 'student','1000','info:name'
刪除rowkey為1000的info列族name這一列數(shù)據(jù),注意delete 只能刪除一列
hbase(main):029:0> deleteall 'student','1000'
刪除rowkey為1000的全部數(shù)據(jù) - 清空表數(shù)據(jù)
hbase(main):035:0> truncate 'student'
清空表的操作順序?yàn)橄萪isable吉执,然后再truncate - 查看表結(jié)構(gòu)
hbase(main):023:0> describe 'student' - 變更表信息
將info列族中的數(shù)據(jù)存放3個(gè)版本
hbase(main):036:0> alter 'student',{NAME=>'info',VERSIONS=>3}
hbase(main):038:0> put 'student','1000','info:name','z'
hbase(main):039:0> put 'student','1000','info:name','j'
hbase(main):040:0> put 'student','1000','info:name','zj'
hbase(main):041:0> get 'student','1000',{COLUMN=>'info:name',VERSIONS=>3} - 刪除表
hbase(main):044:0> disable 'student'
首先需要先讓該表為disable狀態(tài)
hbase(main):045:0> drop 'student'
然后才能drop這個(gè)表
如果直接drop表疯淫,會(huì)報(bào)錯(cuò):ERROR: Table student is enabled. Disable it first - 統(tǒng)計(jì)表數(shù)據(jù)行數(shù)
hbase(main):043:0> count 'student'