hbase 基于命名空间的使用
help
list
创建命名空间
create_namespace ‘my_namespace_test’
查看命名空间
list_namespace
describe_namespace ‘my_namespace_test’
创建表,及其列簇(单列簇、多列簇)
create ‘my_namespace_test:my_table_test_1’, ‘aaaa’
create ‘my_namespace_test:my_table_test_2’, ‘aaaa’,‘bbbbb’
存储数据、查看数据
put ‘my_namespace_test:my_table_test_1’,‘1223’,‘aaaa:1111’,‘1’
get ‘my_namespace_test:my_table_test_1’, ‘1223’
scan ‘my_namespace_test:my_table_test_1’
scan ‘my_namespace_test:my_table_test_1’, {LIMIT=>1}
put ‘my_namespace_test:my_table_test_2’,‘qwx’,‘aaaa:cccc’,‘vasd1’
put ‘my_namespace_test:my_table_test_2’,‘qwx’,‘bbbbb:qwe’,‘cds’
get ‘my_namespace_test:my_table_test_2’, ‘qwx’
scan ‘my_namespace_test:my_table_test_2’
scan ‘my_namespace_test:my_table_test_2’, {LIMIT=>1}
查看命名空间下的表
list_namespace_tables ‘my_namespace_test’
describe ‘my_namespace_test:my_table_test’
清空表内容
truncate ‘my_namespace_test:my_table_test’
删除表,首先禁用表
disable ‘my_namespace_test:my_table_test’
drop ‘my_namespace_test:my_table_test’
删除命名空间,命名空间必须为空
drop_namespace ‘my_namespace_test’
重命名
1、先disable掉表
disable 'recommend_samh:profile_user_test'
2、创建一个快照
snapshot 'recommend_samh:profile_user_test', 'profile_user_test_newSnapshot'
3、克隆这个快照 赋给新的表名
clone_snapshot 'profile_user_test_newSnapshot', 'recommend_samh:profile_user_test_rename'
4、删除之前创建的快照
delete_snapshot 'profile_user_test_newSnapshot'
5、恢复表/删除表
enable 'recommend_samh:profile_user_test'
drop 'recommend_samh:profile_user_test'
详细查看
scan ‘recommend_samh:profile_user’,{‘LIMIT’=>10,‘COLUMNS’=>[‘info:ip’],FILTER=>“SingleColumnValueFilter(‘info’,‘day’,=,‘binary:2021-01-22’)”,TIMERANGE=>[1611245751000, 1611281751000]}
说明:
- 1、‘LIMIT’=>10:显示10行;
- 2、‘COLUMNS’=>[‘info:ip’]:字段选择
- 3、FILTER=>“SingleColumnValueFilter(‘info’,‘day’,=,‘binary:2021-01-22’)” :过滤条件(day=2021-01-22)
- 4、TIMERANGE=>[1611245751000, 1611281751000] :字段更新时间范围(2021-01-22 00:15:51 ~ 2021-01-22 10:15:51)
hbase(main):480:0> scan 'recommend_samh:profile_user',{'LIMIT'=>10,'COLUMNS'=>['info:ip'],FILTER=>"SingleColumnValueFilter('info','day',=,'binary:2021-01-22')",TIMERANGE=>[1611245751000, 1611281751000]}
ROW COLUMN+CELL
0002d2c59a5ca14b:comic column=info:ip, timestamp=1611278940100, value=27.187.225.162
0004451acd9a4860:comic column=info:ip, timestamp=1611278940345, value=111.41.211.9
000a95d55fc593f6:comic column=info:ip, timestamp=1611278940211, value=122.192.13.232
000ea092299a4bdc:comic column=info:ip, timestamp=1611278939746, value=117.181.10.99
000f74d791b9e78d:comic column=info:ip, timestamp=1611278940156, value=112.235.5.144
001279d3ee11357b:comic column=info:ip, timestamp=1611278940690, value=106.127.19.185
00135cdd5b4aad0b:comic column=info:ip, timestamp=1611278940100, value=106.80.139.178
0015b88e306d3232:comic column=info:ip, timestamp=1611278940542, value=36.148.97.116
001a0d29cc3fdb8a:comic column=info:ip, timestamp=1611278940750, value=14.16.128.89
001cd21792df6613:comic column=info:ip, timestamp=1611278940542, value=101.86.151.181