Hbase常用命令

一、进入hbase命令行界面

hbase shell

二、hbase常用命令

 下面是一些常见命令的说明，在hbaseshell中输入help的帮助信息（hbase把命令进行了分类）

COMMAND GROUPS:
  Group name: general
  Commands: processlist, status, table_help, version, whoami

  Group name: ddl
  Commands: alter, alter_async, alter_status, clone_table_schema, 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

  Group name: namespace
  Commands: alter_namespace, create_namespace, describe_namespace, drop_namespace, list_namespace, list_namespace_tables

  Group name: dml
  Commands: append, count, delete, deleteall, get, get_counter, get_splits, incr, put, scan, truncate, truncate_preserve

  Group name: tools
  Commands: assign, balance_switch, balancer, balancer_enabled, catalogjanitor_enabled, catalogjanitor_run, catalogjanitor_switch, cleaner_chore_enabled, cleaner_chore_run, cleaner_chore_switch, clear_block_cache, clear_compaction_queues, clear_deadservers, clear_slowlog_responses, close_region, compact, compact_rs, compaction_state, compaction_switch, decommission_regionservers, flush, get_largelog_responses, get_slowlog_responses, hbck_chore_run, is_in_maintenance_mode, list_deadservers, list_decommissioned_regionservers, major_compact, merge_region, move, normalize, normalizer_enabled, normalizer_switch, recommission_regionserver, regioninfo, rit, snapshot_cleanup_enabled, snapshot_cleanup_switch, split, splitormerge_enabled, splitormerge_switch, stop_master, stop_regionserver, trace, unassign, wal_roll, zk_dump

  Group name: replication
  Commands: add_peer, append_peer_exclude_namespaces, append_peer_exclude_tableCFs, append_peer_namespaces, append_peer_tableCFs, disable_peer, disable_table_replication, enable_peer, enable_table_replication, get_peer_config, list_peer_configs, list_peers, list_replicated_tables, remove_peer, remove_peer_exclude_namespaces, remove_peer_exclude_tableCFs, remove_peer_namespaces, remove_peer_tableCFs, set_peer_bandwidth, set_peer_exclude_namespaces, set_peer_exclude_tableCFs, set_peer_namespaces, set_peer_replicate_all, set_peer_serial, set_peer_tableCFs, show_peer_tableCFs, update_peer_config

  Group name: snapshots
  Commands: clone_snapshot, delete_all_snapshot, delete_snapshot, delete_table_snapshots, list_snapshots, list_table_snapshots, restore_snapshot, snapshot

  Group name: configuration
  Commands: update_all_config, update_config

  Group name: quotas
  Commands: disable_exceed_throttle_quota, disable_rpc_throttle, enable_exceed_throttle_quota, enable_rpc_throttle, list_quota_snapshots, list_quota_table_sizes, list_quotas, list_snapshot_sizes, set_quota

  Group name: security
  Commands: grant, list_security_capabilities, revoke, user_permission

  Group name: procedures
  Commands: list_locks, list_procedures

  Group name: visibility labels
  Commands: add_labels, clear_auths, get_auths, list_labels, set_auths, set_visibility

  Group name: rsgroup
  Commands: add_rsgroup, balance_rsgroup, get_rsgroup, get_server_rsgroup, get_table_rsgroup, list_rsgroups, move_namespaces_rsgroup, move_servers_namespaces_rsgroup, move_servers_rsgroup, move_servers_tables_rsgroup, move_tables_rsgroup, remove_rsgroup, remove_servers_rsgroup, rename_rsgroup

1、一般操作

查询服务器状态：

hbase(main):080:0* status
1 active master, 0 backup masters, 2 servers, 0 dead, 1.5000 average load
Took 0.0149 seconds

查询hbase版本

hbase(main):082:0* version
2.3.4, rafd5e4fc3cd259257229df3422f2857ed35da4cc, Thu Jan 14 21:32:25 UTC 2021
Took 0.0031 seconds

2、DDL操作

创建表

hbase(main):083:0> create 'member','member_id','address','info'
Created table member
Took 0.6371 seconds

查看所有表

hbase(main):090:0* list
TABLE
member
test1
2 row(s)
Took 0.0033 seconds

删除一个表（删除表之前先要disable）

disable 'member'
drop 'member'

查询表是否存在

exists 'member'

判断表是否enable

is_enabled 'member'

判断表是否disable

is_disabled 'member'

3、DML操作

插入表数据

put'member','yoyo','info:birthday','1990-4-23'
put'member','yoyo','info:favorite','movie' 
put'member','yoyo','info:company','youyu'
put'member','yoyo','address:contry','china'
put'member','yoyo','address:province','chongqing'

获取一个id的所有数据

hbase(main):103:0* get 'member','yoyo'
COLUMN                                    CELL
 address:contry                           timestamp=2021-03-22T14:00:55.608, value=china
 address:province                         timestamp=2021-03-22T14:01:02.189, value=chongqing
 info:birthday                            timestamp=2021-03-22T13:59:06.993, value=1990-4-23
 info:company                             timestamp=2021-03-22T14:00:49.285, value=youyu
1 row(s)
Took 0.1130 seconds

获取一个列簇的所有数据

hbase(main):109:0* get 'member','yoyo','info'
COLUMN                                    CELL
 info:birthday                            timestamp=2021-03-22T13:59:06.993, value=1990-4-23
 info:company                             timestamp=2021-03-22T14:00:49.285, value=youyu
 info:favorite                            timestamp=2021-03-22T14:05:12.931, value=movie
1 row(s)
Took 0.0157 seconds

获取一个id，一个列族中一个列的所有数据

hbase(main):113:0> get 'member','yoyo','info:company'
COLUMN                                    CELL
 info:company                             timestamp=2021-03-22T14:00:49.285, value=youyu
1 row(s)
Took 0.0069 seconds

更新一条记录

hbase(main):114:0> put  'member','yoyo','info:birthday','1990-4-22'
Took 0.0070 seconds

全表扫描

scan 'member'

删除id为yoyo，值为info:birthday的字段

hbase(main):146:0> delete  'member','yoyo','info:birthday'
Took 0.0092 seconds

删除整行

hbase(main):150:0> deleteall  'member','yoyo'
Took 0.0057 seconds

查询表中有多少行

count 'member'

清空整张表

truncate 'member'