1、进入hbase shell命令界面。
2、输入help出现命令帮助界面,所有命令分组:
COMMAND GROUPS:
Group name: general
Commands: status, version, whoami
Group name: ddl
Commands: alter, alter_async, alter_status, create, describe, disable, disable_all, drop, drop_all, enable, enable_all, exists, is_disabled, is_enabled, list, show_filters
Group name: dml
Commands: count, delete, deleteall, get, get_counter, incr, put, scan, truncate
Group name: tools
Commands: assign, balance_switch, balancer, close_region, compact, compact_rs, compact_switch, flush, hlog_roll, major_compact, move, move_server, move_table, show_tasks, split, unassign, update_config, zk_dump
Group name: replication
Commands: add_peer, append_peer_tableCFs, disable_peer, enable_peer, list_peers, list_replicated_tables, remove_peer, set_peer_tableCFs, show_peer_tableCFs, start_replication, stop_replication
Group name: snapshot
Commands: clone_snapshot, delete_snapshot, list_snapshots, restore_snapshot, snapshot
Group name: security
Commands: grant, revoke, user_permission
Group name: quota
Commands: get_limit, set_limit
3、命令一般格式和规则:
示例:scan 'tableName', {LIMIT=>10}
格式:命令 '表名', '行名', ['列族', '列名'], {条件行}
等号为 '=>'
4、常用命令:
1)显示所有表:> list
2)获得某行数据所有数据:> get 'table', '100'
3)获得某行某列数据:> get 'table', '100', 'FAMILYNAME:COLUMNNAME'
4)获得某行多列数据:> get 'table', '123', ['FAMILYNAME1:COLUMNNAME1', 'FAMILYNAME2:COLUMNNAME2']
5)浏览多行数据:> scan 'table', {COLUMNS => ['P:UserPopulation'], STARTROW => '1', LIMIT => 10}
6)删除某行某列数据:> delete 'table', '100', 'FAMILYNAME:COLUMNNAME', timeStamps
7)删除某行所有数据:> delete 'table', '100'
8)添加数据:> put 'table', '100', 'FAMILYNAME:COLUMNNAME', 'value', ts1