0
0

HBASE SHELL学习

HBASE SHELL学习

小白的Hbase学习笔记

1.启动hbase

  1. start-all.sh
  3. zkServer.sh start （所有节点）
  5. start-hbase.sh
  7. stop-hbase.sh

2.进入hbase

  1. hbase shell
  3. quit

3.help (查看HBASE SHELL支持的命令)

  1.   Group name: general
  2.   Commands: processlist, status, table_help, version, whoami
  4.   Group name: ddl
  5.   Commands: alter, alter_async, alter_status, create, describe, disable, disable_all, drop, drop_all, enable, enable_all, exists, get_table, is_disabled, is_enabled, list, list_regions, locate_region, show_filters
  7.   Group name: namespace
  8.   Commands: alter_namespace, create_namespace, describe_namespace, drop_namespace, list_namespace, list_namespace_tables
  10.   Group name: dml
  11.   Commands: append, count, delete, deleteall, get, get_counter, get_splits, incr, put, scan, truncate, truncate_preserve

4.general (普遍的)

  1.   Group name: general
  2.   Commands: processlist, status, table_help, version, whoami

查看版本

version

查看HBASE当前版本号

status

5.ddl - 表操作

  1.   Group name: ddl
  2.   Commands: alter, alter_async, alter_status, create, describe, disable, disable_all, drop, drop_all, enable, enable_all, exists, get_table, is_disabled, is_enabled, list, list_regions, locate_region, show_filters
1）create 创建表
  1. 样例：
  3. 默认命名空间下创建mytb1表 列族为info
  5. create 'mytb1','info'
  7. 在db1命名空间下创建表
  9. create_namespace 'db1'
  10. create 'db1:mytb1','info1'
  12. 创建表时指定多个列族
  14. create 'db1:mytb2','info1','info2','info3'
  16. 创建表并指定列族版本
  18. create 'db1:mytb3',{NAME => 'info1',VERSIONS => 3}

t1: 表示表名称

f1: 表示列族

ns1：表示命名空间

Create a table with namespace=ns1 and table qualifier=t1
hbase> create 'ns1:t1', {NAME => 'f1', VERSIONS => 5}

  1. help 'create'
  3. Create a table with namespace=ns1 and table qualifier=t1
  4.   hbase> create 'ns1:t1', {NAME => 'f1', VERSIONS => 5}
  6. Create a table with namespace=default and table qualifier=t1
  7.   hbase> create 't1', {NAME => 'f1'}, {NAME => 'f2'}, {NAME => 'f3'}
  8.   hbase> # The above in shorthand would be the following:
  9.   hbase> create 't1', 'f1', 'f2', 'f3'
  10.   hbase> create 't1', {NAME => 'f1', VERSIONS => 1, TTL => 2592000, BLOCKCACHE => true}
  11.   hbase> create 't1', {NAME => 'f1', CONFIGURATION => {'hbase.hstore.blockingStoreFiles' => '10'}}
  13. Table configuration options can be put at the end.
  14. Examples:
  16.   hbase> create 'ns1:t1', 'f1', SPLITS => ['10', '20', '30', '40']
  17.   hbase> create 't1', 'f1', SPLITS => ['10', '20', '30', '40']
  18.   hbase> create 't1', 'f1', SPLITS_FILE => 'splits.txt', OWNER => 'johndoe'
  19.   hbase> create 't1', {NAME => 'f1', VERSIONS => 5}, METADATA => { 'mykey' => 'myvalue' }
  20.   hbase> # Optionally pre-split the table into NUMREGIONS, using
  21.   hbase> # SPLITALGO ("HexStringSplit", "UniformSplit" or classname)
  22.   hbase> create 't1', 'f1', {NUMREGIONS => 15, SPLITALGO => 'HexStringSplit'}
  23.   hbase> create 't1', 'f1', {NUMREGIONS => 15, SPLITALGO => 'HexStringSplit', REGION_REPLICATION => 2, CONFIGURATION => {'hbase.hregion.scan.loadColumnFamiliesOnDemand' => 'true'}}
  24.   hbase> create 't1', {NAME => 'f1', DFS_REPLICATION => 1}
  26. You can also keep around a reference to the created table:
  28.   hbase> t1 = create 't1', 'f1'
2）describe 查看表的具体信息
  1. help 'describe'
  3. Describe the named table. For example:
  4.   hbase> describe 't1'
  5.   hbase> describe 'ns1:t1'
  7. Alternatively, you can use the abbreviated 'desc' for the same thing.
  8.   hbase> desc 't1'
  9.   hbase> desc 'ns1:t1'
  11. 样例：
  13. describe 'db1:mytb2'
  15. 表中的列族信息 可以看出 每个列族都维护自己的一个版本信息 一个列族对应一个store
  17. describe 'db1:mytb3'
  18. desc 'db1:mytb3'

3）alter 修改表
  1. help 'alter'
  3. hbase> alter 't1', NAME => 'f1', VERSIONS => 5
  5. hbase> alter 'ns1:t1', 'delete' => 'f1'
  7. 样例
  9. 1.修改列族版本号
  10. alter 'db1:mytb3',NAME => 'info1',VERSIONS => 4
  12. 2.删除列族
  13. alter 'db1:mytb2','delete' => 'info3'

4）drop 删除表
  1. help 'drop'
  3. Drop the named table. Table must first be disabled:
  4.   hbase> drop 't1'
  5.   hbase> drop 'ns1:t1'
  7. 注意：使用drop操作时 先需要执行disable 
  9. help 'disable'
  11. Start disable of named table:
  12.   hbase> disable 't1'
  13.   hbase> disable 'ns1:t1'
  15. 样例：
  17. 1.disable 'db1:mytb2'
  18. 2.drop'db1:mytb2'

5）关闭及启用表
  1. 1.关闭表操作
  3. disable 'db1:mytb1'
  4. desc 'db1:mytb1'
  6. 2.启用表操作
  8. enable'db1:mytb1'
  9. desc 'db1:mytb1'

6.namespace (命名空间)

  1.   Group name: namespace
  2.   Commands: alter_namespace, create_namespace, describe_namespace, drop_namespace, list_namespace, list_namespace_tables
1）create_namespace 创建命名空间
  1. help 'create_namespace'
  3. hbase> create_namespace 'ns1'
  4. hbase> create_namespace 'ns1', {'PROPERTY_NAME'=>'PROPERTY_VALUE'}
  6. 样例：
  8. create_namespace 'mydb1'
  10. create_namespace 'mydb2',{'create_time' => '2022-04-25'}
2）list_namespace 查看当前命名空间

样例：list_namespace

结果：

default --用户默认使用的命名空间

hbase --hbase中存放的是HBase内置的表

mydb1 --自己创建的命名空间

3）describe_namespace 查看命名空间的详细信息
  1. help 'describe_namespace'
  3. hbase> describe_namespace 'ns1'
  5. 样例：
  7. describe_namespace 'mydb1'

4）alter_namespace 修改命名空间
  1. help 'alter_namespace'
  3. To add/modify a property:
  5.   hbase> alter_namespace 'ns1', {METHOD => 'set', 'PROPERTY_NAME' => 'PROPERTY_VALUE'}
  7. To delete a property:
  9.   hbase> alter_namespace 'ns1', {METHOD => 'unset', NAME=>'PROPERTY_NAME'}
  11. 样例：
  13. 增加author配置并且修改create_time配置
  15. alter_namespace 'mydb2',{METHOD => 'set','author' => 'act','create_time' => '2022-04-25'}
  16. alter_namespace 'mydb2',{'METHOD' => 'set','author' => 'act','create_time' => '2022-04-15'}
  18. 删除create_time配置
  20. alter_namespace 'mydb2',{METHOD => 'unset',NAME => 'author'}

5）drop_namespace 删除空的命名空间
  1. help 'drop_namespace'
  3. Drop the named namespace. The namespace must be empty.
  5. drop_namespace 'mydb2'
6）list_namespace_tables 查看指定命名空间下的表
  1. help 'list_namespace_tables'
  3. hbase> list_namespace_tables 'ns1'
  5. list_namespace_tables 'default'

7.dml

1）put 上传及修改数据操作
  1. help 'put'
  3. r1 表示 rowKey
  4. c1 表示 列名称
  6.   hbase> put 'ns1:t1', 'r1', 'c1', 'value'
  7.   hbase> put 't1', 'r1', 'c1', 'value'
  8.   hbase> put 't1', 'r1', 'c1', 'value', ts1
  9.   hbase> put 't1', 'r1', 'c1', 'value', {ATTRIBUTES=>{'mykey'=>'myvalue'}}
  10.   hbase> put 't1', 'r1', 'c1', 'value', ts1, {ATTRIBUTES=>{'mykey'=>'myvalue'}}
  11.   hbase> put 't1', 'r1', 'c1', 'value', ts1, {VISIBILITY=>'PRIVATE|SECRET'}
  13. 样例：
  15. create 'db1:stu','info'
  17. list_namespace_tables 'db1'
  19. desc 'db1:stu'
  21. put 'db1:stu','1001','info:name','zhangsan'
  23. 注：修改数据可以直接用put上传最新数据进行替换
  24.

2）get 获取一行数据操作
  1. help 'get'
  3.   hbase> t.get 'r1'
  4.   hbase> t.get 'r1', {TIMERANGE => [ts1, ts2]}
  5.   hbase> t.get 'r1', {COLUMN => 'c1'}
  6.   hbase> t.get 'r1', {COLUMN => ['c1', 'c2', 'c3']}
  7.   hbase> t.get 'r1', {COLUMN => 'c1', TIMESTAMP => ts1}
  8.   hbase> t.get 'r1', {COLUMN => 'c1', TIMERANGE => [ts1, ts2], VERSIONS => 4}
  9.   hbase> t.get 'r1', {COLUMN => 'c1', TIMESTAMP => ts1, VERSIONS => 4}
  10.   hbase> t.get 'r1', {FILTER => "ValueFilter(=, 'binary:abc')"}
  11.   hbase> t.get 'r1', 'c1'
  12.   hbase> t.get 'r1', 'c1', 'c2'
  13.   hbase> t.get 'r1', ['c1', 'c2']
  14.   hbase> t.get 'r1', {CONSISTENCY => 'TIMELINE'}
  15.   hbase> t.get 'r1', {CONSISTENCY => 'TIMELINE', REGION_REPLICA_ID => 1}
  17. get 'db1:stu','1001'
  19. put 'db1:stu','1001','info:age','12'
  21. get 'db1:stu','1001'
  23. 获取指定RowKey中某一列数据
  24. get 'db1:stu','1001','info:age'
  26. 获取指定RowKey下的多列数据
  28. get 'db1:stu','1001','info:age','info:name'

3）scan 获取表中所有数据
  1. help 'scan'
  3. scan 'db1:stu'
  5. 插入多条数据：
  7. put 'db1:stu','1001','info:name','zhjangsan'
  8. put 'db1:stu','1001','info:age','12'
  9. put 'db1:stu','1001','info:clazz','clazz1'
  11. put 'db1:stu','1002','info:name','lisi'
  12. put 'db1:stu','1002','info:age','12'
  13. put 'db1:stu','1002','info:clazz','clazz2'
  15. put 'db1:stu','1003','info:name','wangwu'
  16. put 'db1:stu','1003','info:age','12'
  17. put 'db1:stu','1003','info:clazz','25'
  19. scan 'db1:stu'
  21. put 'db1:stu','2033','info:name','wangwu'
  22. put 'db1:stu','2033','info:age','12'
  23. put 'db1:stu','2033','info:clazz','25'
  25. scan 'db1:stu'
  27. put 'db1:stu','1004','info:name','wangwu'
  28. put 'db1:stu','1004','info:age','12'
  29. put 'db1:stu','1004','info:clazz','25'
  31. scan 'db1:stu'
  33. 发现1004在2033前面 所以说rowKey是按照字典顺序排序的
  35. put 'db1:stu','2044','info:name','liliu'
  36. put 'db1:stu','2044','info:age','12'
  37. put 'db1:stu','2044','info:clazz','25'
  39. scan 'db1:stu'
  41. put 'db1:stu','10010','info:name','wan2gwu'
  42. put 'db1:stu','10010','info:age','12'
  43. put 'db1:stu','10010','info:clazz','25'
  45. scan 'db1:stu'
  47. put 'db1:stu','1001$','info:name','zhjangsan'
  48. put 'db1:stu','1001$','info:age','12'
  49. put 'db1:stu','1001$','info:clazz','clazz1'
  51. scan 'db1:stu'
  53. 发现10010在1001后面 所以说rowKey是按照字典顺序排序的
  55. ROWKEY是根据字典排序 并且排序的依据是按位比较ASCII码表

  1. help 'scan'
  3. scan 'db1:stu',{LIMIT => 3}
  5. 按ROWKEY范围进行取值 左闭右开 取值包含STARTROW 不包含STOPROW 
  6. scan 'db1:stu',{STARTROW => '1001',STOPROW => '1004'}
  8. 根据ASCII码取值
  9. scan 'db1:stu',{STARTROW => '1001',STOPROW => '1001~'}
  11. scan 'db1:stu',{STARTROW => '1001!',STOPROW => '1001~'}
  13. 查看表中所有数据并展示所有版本信息
  15. scan 'db1:stu',{RAW => true,VERSIONS => 10}

4）list 查看所有表

list

5）count 统计表中数据量

count 'db1:stu'

6）删除列操作
  1. help 'delete'
  3. scan 'db1:stu'
  5. delete 'db1:stu','1001','info:age',时间戳
7）删除一个ROWKEY
  1. help 'deleteall'
  3.   hbase> t.deleteall 'r1'
  4.   hbase> t.deleteall 'r1', 'c1'
  5.   hbase> t.deleteall 'r1', 'c1', ts1
  6.   hbase> t.deleteall 'r1', 'c1', ts1, {VISIBILITY=>'PRIVATE|SECRET'}
  8. deleteall 'db1:stu','1001'
8）清空表
  1. help 'truncate'
  3. Disables, drops and recreates the specified table.
  5. 样例：
  7. truncate 'db1:stu'

标签： hbase 学习 数据库
本文转载自: https://blog.csdn.net/2301_77836489/article/details/139194885
版权归原作者 难以触及的高度 所有， 如有侵权，请联系我们删除。
登录后发布评论

“HBASE SHELL学习”的评论:

还没有评论
关于作者
...
overfit同步小助手
文章同步
相关阅读

网络安全法-网络运行安全

使用selenium/drissionpage时如何阻止chrome自动跳转http到https

docker desktop 里部署的Open WebUI 管理员密码忘记了的处理方法

在ubuntu20.04中搭建onsite比赛运行环境

利用开源的低代码表单设计器FcDesigner高效管理和渲染复杂表单结构

Kafka学习笔记

【前端】浏览器输入url到页面呈现发生了什么？

文章导航
HBASE SHELL学习