HBase常用命令及使用

常用HBase Shell命令

名称命令表达式创建表create '表名称’，'列名称1’，'列名称2’，...'列名称n'添加记录put '表名称’,'行名称'，‘值’查看记录get ‘表名称’，‘行名称’查看表的总记录数count ‘表名称’删除记录delete '表名称'，‘行名称’，‘列名称’删除表1.disable‘表名称’  2.drop ‘表名称’  （先要屏蔽表，才能删除表）查看所以记录scan ‘表名称’查看某个表中某列的数据scan ‘表名称’，[‘列名称’]更新记录更新及添加   put '表名称’,'行名称'，‘值’

命令操作

创建表

create 'ns2:user','info','score'  

hbase(main):008:0> create 'ns2:user','info','score'0 row(s) in 1.4340 seconds=> Hbase::Table - ns2:user

插入/添加数据

put 'ns2:user','1','info:name','xiaojian'

put 'ns2:user','1','info:age','20'

put 'ns2:user','1','score:math','78'

=> Hbase::Table - ns2:userhbase(main):009:0> put 'ns2:user','1','info:name','xioajian'0 row(s) in 0.3140 secondshbase(main):010:0> put 'ns2:user','1','info:age','20'0 row(s) in 0.0290 secondshbase(main):011:0> put 'ns2:user','1','score:math','78'0 row(s) in 0.0470 seconds

查看所有记录

scan 'ns2:user'

hbase(main):012:0> scan 'ns2:user'ROW              COLUMN+CELL                                   1               column=info:age, timestamp=1502543902061, val                 ue=20                                         1               column=info:name, timestamp=1502543891679, va                 lue=xioajian                                  1               column=score:math, timestamp=1502543920185, v                 alue=78                                      1 row(s) in 0.0920 seconds

表描述

describe 'ns2:user'

hbase(main):014:0> describe 'ns2:user'DESCRIPTION                              ENABLED               'ns2:user', {NAME => 'info', DATA_BLOCK true                  _ENCODING => 'NONE', BLOOMFILTER => 'RO                       W', REPLICATION_SCOPE => '0', VERSIONS                        => '1', COMPRESSION => 'NONE', MIN_VERS                       IONS => '0', TTL => 'FOREVER', KEEP_DEL                       ETED_CELLS => 'false', BLOCKSIZE => '65                       536', IN_MEMORY => 'false', BLOCKCACHE                        => 'true'}, {NAME => 'score', DATA_BLOC                       K_ENCODING => 'NONE', BLOOMFILTER => 'R                       OW', REPLICATION_SCOPE => '0', VERSIONS                        => '1', COMPRESSION => 'NONE', MIN_VER                       SIONS => '0', TTL => 'FOREVER', KEEP_DE                       LETED_CELLS => 'false', BLOCKSIZE => '6                       5536', IN_MEMORY => 'false', BLOCKCACHE                        => 'true'}                                                  1 row(s) in 0.1550 seconds

更新表

put 'ns2:user','1','info:name','liuxioajian'

hbase(main):021:0> scan 'ns2:user'ROW              COLUMN+CELL                                   1               column=info:age, timestamp=1502543902061, val                 ue=20                                         1               column=info:name, timestamp=1502544557979, va                 lue=liuxioajian                               1               column=score:math, timestamp=1502543920185, v                 alue=78                                      1 row(s) in 0.0590 seconds

删除记录

delete 'ns2:user','1','info:name'

删除表

drop 'ns2:user'(报错)

hbase(main):022:0> drop 'ns2:user'ERROR: Table ns2:user is enabled. Disable it first.'Here is some help for this command:Drop the named table. Table must first be disabled:  hbase> drop 't1'  hbase> drop 'ns1:t1'

先把表设置为disable

disable 'ns2:user'

hbase(main):001:0> disable 'ns2:user'2017-08-12 21:36:46,499 WARN  [main] util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable0 row(s) in 15.4270 seconds

再删除表
drop ‘ns2:user’

hbase(main):002:0> drop 'ns2:user'0 row(s) in 0.7480 seconds

查看命名空间下的所有表

list_namespace_tables 'ns2'

hbase(main):012:0> list_namespace_tables 'ns2'TABLE                                                         person                                                        student

user表不在，因为上面把表删除了

所以下面又建了张user表

hbase(main):018:0> scan 'ns2:user'ROW              COLUMN+CELL                                   1               column=info:age, timestamp=1502545506778, val                 ue=20                                         1               column=info:name, timestamp=1502545498698, va                 lue=xiaojian                                  1               column=score:math, timestamp=1502545526200, v                 alue=90                                       2               column=info:age, timestamp=1502545829642, val                 ue=22                                         2               column=info:name, timestamp=1502545820947, va                 lue=zhangsan                                  2               column=score:math, timestamp=1502545807495, v                 alue=68                                      2 row(s) in 0.1000 seconds

get查询

查一行

get 'ns2:user','2'

hbase(main):019:0> get 'ns2:user','2'COLUMN           CELL                                          info:age        timestamp=1502545829642, value=22             info:name       timestamp=1502545820947, value=zhangsan       score:math      timestamp=1502545807495, value=68            3 row(s) in 0.0710 seconds

查一行的一列（cell单元）

get 'ns2:user','2','info:name'

hbase(main):020:0> get 'ns2:user','2','info:name'COLUMN           CELL                                          info:name       timestamp=1502545820947, value=zhangsan      1 row(s) in 0.0330 seconds

查询表的总记录数

count 'ns2:user'

hbase(main):021:0> count 'ns2:user'2 row(s) in 0.0730 seconds=> 2

命名空间

创建命名空间  create_namespace 'ns3'

查看命名空间  list_namespace

hbase(main):024:0> list_namespaceNAMESPACE                                                     default                                                       hbase                                                         ns1                                                           ns2                                                           ns3                                                           5 row(s) in 0.0790 seconds