进入Hbase shell
进入Hbase shell的操作:输入命令Hbase shell
常用语法
1. 创建表
语法
create <table>, {NAME => <family>, VERSIONS => <VERSIONS>}
例子:创建一个User表,并且有一个info列族create ‘User’,‘info’
2. 查看详情表
describe ‘User’
3. 表修改
删除指定的列族:alter ‘User’, ‘delete’ => ‘info’
增加新的列族:alter ‘User’, NAME => ‘info’
4.插入数据
语法:put <table>,<rowkey>,<family:column>,<value>
put 'User', 'row1', 'info:name', 'xiaoming'
put 'User', 'row2', 'info:age', '18'
put 'User', 'row3', 'info:sex', 'man'
5.查询所有记录
语法:scan <table>, {COLUMNS => [ <family:column>,.... ], LIMIT => num}
扫描所有记录:scan ‘User’
扫描前2条:scan ‘User’, {LIMIT => 2}
范围查询 STARTROW(开始rowkey) ENDROW(结束rowkey) :
scan 'User', {STARTROW => 'row2'}
scan 'User', {STARTROW => 'row2', ENDROW => 'row2'}
scan 'User', {STARTROW => 'row2', ENDROW => 'row3'}
6.统计表记录数
语法:count <table>, {INTERVAL => intervalNum, CACHE => cacheNum}
INTERVAL设置多少行显示一次及对应的rowkey,默认1000;CACHE每次去取的缓存区大小,默认是10,调整该参数可提高查询速度:count ‘User’
7.删除
删除列:delete ‘User’, ‘row1’, ‘info:age’
指定rowkey删除:deleteall ‘User’, ‘row2’
删除表中所有数据:truncate ‘User’
8.表管理
禁用表:disable ‘User’
启用表:enable ‘User’
测试表是否存在:exists ‘User’
删除表:先disable disable ‘User’ drop ‘User’