-- 配置环境变量,因为在hbase中有的地方可能用到了环境变量
-- bin/start-hbase.sh
-- bin/hbase shell
-- 访问http://mini0:16010/ 可以看浏览器页面
名称 命令表达式
查看所有表 list
list
创建表 create '表名', '列族名1','列族名2','列族名N'
create 'www.qq.com20170630','movie','music','games'
create 'www.baidu.com20170630','search','games'
描述表 describe ‘表名’
describe 'www.baidu.com20170630'
判断表存在 exists '表名'
exists 'www.baidu.com20170630'
判断是否禁用启用表 is_enabled '表名'
is_disabled ‘表名’
is_disabled 'www.baidu.com20170630'
添加记录 put ‘表名’, ‘rowKey’, ‘列族 : 列‘ , '值'
-- 好像不能添加多了列族:列
put 'www.baidu.com20170630','rowkey123','games:usercount','12'
put 'www.baidu.com20170630','rowkey123','search:bagua','huang xiao ming'
put 'www.baidu.com20170630','rowkey1236','games:usercount','200'
put 'www.baidu.com20170630','rowkey1234','search:bagua','hxm'
put 'www.baidu.com20170630','rowkey1234','games:usercount','12'
put 'www.baidu.com20170630','rowkey1234','search:bagua','210'
put 'www.baidu.com20170630','rowkey1234','games:usercount','200'
put 'www.baidu.com20170630','rowkey1234','search:bagua','hxm'
put 'www.qq.com20170630','rowkey123','movie:dhxy','zxc'
put 'www.qq.com20170630','rowkey123','music:singer'
put 'www.qq.com20170630','rowkey123', 'movie:dhxy','zxc
put 'www.qq.com20170630','rowkey1231','games:usercount','100'
put 'www.qq.com20170630','rowkey1231','music:singer','chenyixun'
查看记录rowkey下的所有数据 get '表名' , 'rowKey'
get 'www.baidu.com20170630','rowkey123'
get 'www.qq.com20170630','rowkey1232'
get 'www.baidu.com20170630','rowkey1234'
查看表中的记录总数 count '表名'
count 'www.qq.com20170630'
count 'www.qq.com20170630'
获取某个列族 get '表名','rowkey'
get 'www.qq.com20170630','rowkey123'
get 'www.baidu.com20170630','rowkey123','games'
获取某个列族的某个列 get '表名','rowkey','列族:列’
get 'www.baidu.com20170630','rowkey123','games:usercount'
获取某个列族的某几个列
get 't02' 'rowkey',{COLUMN=>['liezu:lieming','liezu:lieming']}
删除记录 delete ‘表名’ ,‘行名’ , ‘列族:列'
delete 'www.qq.com20170630','rowkey123','movie:dhxy'
删除整行 deleteall '表名','rowkey'
deleteall 'www.qq.com20170630','rowkey123'
删除一张表 先要屏蔽该表,才能对该表进行删除
第一步 disable ‘表名’ ,
disable 'www.baidu.com20170630'
第二步 drop '表名'
drop 'www.baidu.com20170630'
清空表 truncate '表名'
truncate 'www.qq.com20170630'
查看所有记录 scan "表名"
scan 'www.qq.com20170630'
scan 'www.baidu.com20170630'
查看某个表某个列中所有数据 scan "表名" , {COLUMNS=>'列族名:列名'}
更新记录 就是重写一遍,进行覆盖,hbase没有修改,都是追加
put 'www.qq.com20170630','rowkey1231','music:singer','fanweiqi','movie:hjzc','wt'