Hadoop学习笔记（十五）---Hbase shell命令的使用

来源：互联网发布：mac雷蛇驱动安装失败编辑：程序博客网时间：2024/05/02 00:01

1.启动hbase，进入hbase文件夹下面的bin文件夹，然后执行命令：

hbase shell

[root@hadoop0 bin]# hbase shellHBase Shell; enter 'help<RETURN>' for list of supported commands.Type "exit<RETURN>" to leave the HBase ShellVersion 0.98.12.1-hadoop1, rb00ec5da604d64a0bdc7d92452b1e0559f0f5d73, Sun May 17 12:22:29 PDT 2015hbase(main):001:0>

2。创建表：

create 'users','user_id', 'address', 'info'

表users,三个列簇：user_id, address, info

3.查看所有表：list

hbase(main):003:0> listTABLE                                                                                                                                                                       users                                                                                                                                                                       1 row(s) in 0.0400 seconds

4.查看表结构：describe 'users'

hbase(main):004:0> describe 'users'Table users is ENABLED                                                                                                                                                      users                                                                                                                                                                       COLUMN FAMILIES DESCRIPTION                                                                                                                                                 {NAME => 'address', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}                                                                      {NAME => 'info', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}                                                                         {NAME => 'user_id', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}                                                                      3 row(s) in 0.1000 seconds

5.删除表：

表不能直接删除，需要先进行disable操作：

如果直接删除会报下面的错误：

hbase(main):007:0> drop 'user_tmp'ERROR: Table user_tmp 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：

hbase(main):008:0> disable 'user_tmp'0 row(s) in 1.4120 seconds

hbase(main):010:0> drop 'user_tmp'0 row(s) in 0.2320 seconds

6.查看表是否存在：

hbase(main):013:0> exists 'users'Table users does exist                                                                                                                                                      0 row(s) in 0.0330 seconds

7.查看是否禁止：

hbase(main):016:0> is_enabled 'users'true                                                                                                                                                                        0 row(s) in 0.0410 seconds

hbase(main):002:0> is_disabled 'users'false                                                                                                                                                                       0 row(s) in 0.0270 seconds

7.插入数据：

hbase(main):001:0> put 'users', 'xiaoming','info:company','baidu'

8.查看表中的数据：

scan 'users'

9.获得小明的信息：

hbase(main):003:0> get 'users','xiaoming'COLUMN                                       CELL                                                                                                                            info:age                                    timestamp=1433712506712, value=22                                                                                               info:company                                timestamp=1433712630400, value=baidu                                                                                           2 row(s) in 0.0560 seconds

只查看年龄：

hbase(main):004:0> get 'users','xiaoming','info:age'COLUMN                                       CELL                                                                                                                            info:age                                    timestamp=1433712506712, value=22                                                                                              1 row(s) in 0.0280 seconds

10.更新记录：

hbase(main):007:0> put 'users','xiaoming','info:age','24'0 row(s) in 0.0140 seconds

现在查看年龄就是最新的年龄：

hbase(main):009:0> get 'users','xiaoming','info:age'COLUMN                                       CELL                                                                                                                            info:age                                    timestamp=1433713054227, value=24                                                                                              1 row(s) in 0.0140 seconds

怎么查看历史记录呢？：

查看上一个数据：

hbase(main):011:0> get 'users','xiaoming',{COLUMN=>'info:age',VERSIONS=>2}

显示时间戳数据：

hbase(main):016:1> get 'users','xiaoming',{COLUMN=>'info:age',TIMESTAMP=>1433713054227}

删除数据：

delete 'users','xiaoming','info:age'

0 0