Hbase shell 常用命令

来源：互联网发布：马克飞象 mac客户端编辑：程序博客网时间：2024/06/07 10:14

下面我们看看HBase Shell的一些基本操作命令，我列出了几个常用的HBase Shell命令，如下：

名称

命令表达式

创建表

create '表名称', '列名称1','列名称2','列名称N'

添加记录

put '表名称', '行名称', '列名称:', '值'

查看记录

get '表名称', '行名称'

查看表中的记录总数

count '表名称'

删除记录

delete '表名' ,'行名称' , '列名称'

删除一张表

先要屏蔽该表，才能对该表进行删除，第一步 disable '表名称' 第二步 drop '表名称'

查看所有记录

scan "表名称"

查看某个表某个列中所有数据

scan "表名称" , ['列名称:']

更新记录

就是重写一遍进行覆盖

下面是一些常见命令的说明，在hbaseshell中输入help的帮助信息，在本文中，我们先介绍前3个，后面2个，将在下一篇博文中介绍。

COMMAND GROUPS:

Group name: general

Commands: status, version

Group name: ddl

Commands: alter, create, describe, disable,drop, enable, exists, is_disabled, is_enabled, list

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, flush, major_compact, move, split, unassign, zk_dump

Group name: replication

Commands: add_peer, disable_peer,enable_peer, remove_peer, start_replication, stop_replication

一、一般操作

1.查询服务器状态

hbase(main):024:0>status

3 servers, 0 dead,1.0000 average load

2.查询hive版本

hbase(main):025:0>version

0.90.4, r1150278,Sun Jul 24 15:53:29 PDT 2011

二、DDL操作

1.创建一个表

hbase(main):011:0>create 'member','member_id','address','info'

0 row(s) in 1.2210seconds

2.获得表的描述

hbase(main):012:0>list

TABLE

member

1 row(s) in 0.0160seconds

hbase(main):006:0>describe 'member'

DESCRIPTION ENABLED

{NAME => 'member', FAMILIES => [{NAME=> 'address', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0', true

VERSIONS => '3', COMPRESSION => 'NONE',TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY => 'fa

lse', BLOCKCACHE => 'true'}, {NAME =>'info', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0', VERSI

ONS => '3', COMPRESSION => 'NONE', TTL=> '2147483647', BLOCKSIZE => '65536', IN_MEMORY => 'false',

BLOCKCACHE => 'true'}]}

1 row(s) in 0.0230seconds

3.删除一个列族，alter，disable，enable

我们之前建了3个列族，但是发现member_id这个列族是多余的，因为他就是主键，所以我们要将其删除。

hbase(main):003:0>alter 'member',{NAME=>'member_id',METHOD=>'delete'}

ERROR: Table memberis enabled. Disable it first before altering.

报错，删除列族的时候必须先将表给disable掉。

hbase(main):004:0>disable 'member'

0 row(s) in 2.0390seconds

hbase(main):005:0>alter'member',{NAME=>'member_id',METHOD=>'delete'}

0 row(s) in 0.0560seconds

hbase(main):006:0>describe 'member'

DESCRIPTION ENABLED

{NAME => 'member', FAMILIES => [{NAME=> 'address', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0',false

VERSIONS => '3', COMPRESSION => 'NONE',TTL => '2147483647', BLOCKSIZE => '65536', IN_MEMORY => 'fa

lse', BLOCKCACHE => 'true'}, {NAME =>'info', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0', VERSI

ONS => '3', COMPRESSION => 'NONE', TTL=> '2147483647', BLOCKSIZE => '65536', IN_MEMORY => 'false',

BLOCKCACHE => 'true'}]}

1 row(s) in 0.0230seconds

该列族已经删除，我们继续将表enable

hbase(main):008:0> enable 'member'

0 row(s) in 2.0420seconds

4.列出所有的表

hbase(main):028:0>list

TABLE

member

temp_table

2 row(s) in 0.0150seconds

5.drop一个表

hbase(main):029:0>disable 'temp_table'

0 row(s) in 2.0590seconds

hbase(main):030:0>drop 'temp_table'

0 row(s) in 1.1070seconds

6.查询表是否存在

hbase(main):021:0>exists 'member'

Table member doesexist

0 row(s) in 0.1610seconds

7.判断表是否enable

hbase(main):034:0>is_enabled 'member'

true

0 row(s) in 0.0110seconds

8.判断表是否disable

hbase(main):032:0>is_disabled 'member'

false

0 row(s) in 0.0110seconds

三、DML操作

1.插入几条记录

put'member','scutshuxue','info:age','24'

put'member','scutshuxue','info:birthday','1987-06-17'

put'member','scutshuxue','info:company','alibaba'

put'member','scutshuxue','address:contry','china'

put'member','scutshuxue','address:province','zhejiang'

put'member','scutshuxue','address:city','hangzhou'

put'member','xiaofeng','info:birthday','1987-4-17'

put'member','xiaofeng','info:favorite','movie'

put'member','xiaofeng','info:company','alibaba'

put'member','xiaofeng','address:contry','china'

put'member','xiaofeng','address:province','guangdong'

put'member','xiaofeng','address:city','jieyang'

put'member','xiaofeng','address:town','xianqiao'

2.获取一条数据

获取一个id的所有数据

hbase(main):001:0>get 'member','scutshuxue'

COLUMN CELL

address:city timestamp=1321586240244, value=hangzhou

address:contry timestamp=1321586239126, value=china

address:province timestamp=1321586239197, value=zhejiang

info:age timestamp=1321586238965, value=24

info:birthday timestamp=1321586239015, value=1987-06-17

info:company timestamp=1321586239071, value=alibaba

6 row(s) in 0.4720seconds

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

hbase(main):002:0>get 'member','scutshuxue','info'

COLUMN CELL

info:age timestamp=1321586238965, value=24

info:birthday timestamp=1321586239015, value=1987-06-17

info:company timestamp=1321586239071, value=alibaba

3 row(s) in 0.0210seconds

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

hbase(main):002:0>get 'member','scutshuxue','info:age'

COLUMN CELL

info:age timestamp=1321586238965, value=24

1 row(s) in 0.0320seconds

6.更新一条记录

将scutshuxue的年龄改成99

hbase(main):004:0>put 'member','scutshuxue','info:age' ,'99'

0 row(s) in 0.0210seconds

hbase(main):005:0>get 'member','scutshuxue','info:age'

COLUMN CELL

info:age timestamp=1321586571843, value=99

1 row(s) in 0.0180seconds

3.通过timestamp来获取两个版本的数据

hbase(main):010:0>get 'member','scutshuxue',{COLUMN=>'info:age',TIMESTAMP=>1321586238965}

COLUMN CELL

info:age timestamp=1321586238965, value=24

1 row(s) in 0.0140seconds

hbase(main):011:0>get 'member','scutshuxue',{COLUMN=>'info:age',TIMESTAMP=>1321586571843}

COLUMN CELL

info:age timestamp=1321586571843, value=99

1 row(s) in 0.0180seconds

4.全表扫描：

hbase(main):013:0>scan 'member'

ROW COLUMN+CELL

scutshuxue column=address:city, timestamp=1321586240244, value=hangzhou

scutshuxue column=address:contry, timestamp=1321586239126, value=china

scutshuxue column=address:province, timestamp=1321586239197, value=zhejiang

scutshuxue column=info:age,timestamp=1321586571843, value=99

scutshuxue column=info:birthday, timestamp=1321586239015, value=1987-06-17

scutshuxue column=info:company, timestamp=1321586239071, value=alibaba

temp column=info:age, timestamp=1321589609775, value=59

xiaofeng column=address:city, timestamp=1321586248400, value=jieyang

xiaofeng column=address:contry, timestamp=1321586248316, value=china

xiaofeng column=address:province, timestamp=1321586248355, value=guangdong

xiaofeng column=address:town, timestamp=1321586249564, value=xianqiao

xiaofeng column=info:birthday, timestamp=1321586248202, value=1987-4-17

xiaofeng column=info:company, timestamp=1321586248277, value=alibaba

xiaofeng column=info:favorite, timestamp=1321586248241, value=movie

3 row(s) in 0.0570seconds

5.删除id为temp的值的‘info:age’字段

hbase(main):016:0>delete 'member','temp','info:age'

0 row(s) in 0.0150seconds

hbase(main):018:0>get 'member','temp'

COLUMN CELL

0 row(s) in 0.0150seconds

6.删除整行

hbase(main):001:0>deleteall 'member','xiaofeng'

0 row(s) in 0.3990seconds

7.查询表中有多少行：

hbase(main):019:0>count 'member'

2 row(s) in 0.0160seconds

8.给‘xiaofeng’这个id增加'info:age'字段，并使用counter实现递增

hbase(main):057:0*incr 'member','xiaofeng','info:age'

COUNTER VALUE = 1

hbase(main):058:0>get 'member','xiaofeng','info:age'

COLUMN CELL

info:age timestamp=1321590997648, value=\x00\x00\x00\x00\x00\x00\x00\x01

1 row(s) in 0.0140seconds

hbase(main):059:0>incr 'member','xiaofeng','info:age'

COUNTER VALUE = 2

hbase(main):060:0>get 'member','xiaofeng','info:age'

COLUMN CELL

info:age timestamp=1321591025110, value=\x00\x00\x00\x00\x00\x00\x00\x02

1 row(s) in 0.0160seconds

获取当前count的值

hbase(main):069:0>get_counter 'member','xiaofeng','info:age'

COUNTER VALUE = 2

9.将整张表清空：

hbase(main):035:0>truncate 'member'

Truncating 'member'table (it may take a while):

- Disabling table...

- Dropping table...

- Creating table...

0 row(s) in 4.3430seconds

可以看出，hbase是先将掉disable掉，然后drop掉后重建表来实现truncate的功能的。

下面我们看看HBase Shell的一些基本操作命令，我列出了几个常用的HBase Shell命令，如下：

名称

命令表达式

创建表

create '表名称', '列名称1','列名称2','列名称N'

添加记录

put '表名称', '行名称', '列名称:', '值'

查看记录

get '表名称', '行名称'

查看表中的记录总数

count '表名称'

删除记录

delete '表名' ,'行名称' , '列名称'

删除一张表

先要屏蔽该表，才能对该表进行删除，第一步 disable '表名称' 第二步 drop '表名称'

查看所有记录

scan "表名称"

查看某个表某个列中所有数据

scan "表名称" , ['列名称:']

更新记录

就是重写一遍进行覆盖

一、一般操作

1.查询服务器状态

hbase(main):011:0> status
1 active master, 0 backup masters, 1 servers, 0 dead, 4.0000 average load

2.查询版本

hbase(main):012:0> version
1.2.1, r8d8a7107dc4ccbf36a92f64675dc60392f85c015, Wed Mar 30 11:19:21 CDT 2016

二、DDL操作

1.创建一个表

hbase(main):013:0> create 'table','column_famaly','column_famaly1','column_famaly2'
0 row(s) in 94.9160 seconds

=> Hbase::Table - table

2.列出所有表

hbase(main):014:0> list
TABLE
stu
table
test
3 row(s) in 0.0570 seconds

=> ["stu", "table", "test"]

3.获得表的描述

hbase(main):015:0> describe 'table'
Table table is ENABLED
table
COLUMN FAMILIES DESCRIPTION
{NAME => 'column_famaly', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', R
EPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS =>
'0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_
MEMORY => 'false', BLOCKCACHE => 'true'}
{NAME => 'column_famaly1', 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 => 'column_famaly2', 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.0430 seconds

4.删除一个列族 alter,disable，enable

hbase(main):016:0> alter 'table',{NAME=>'column_famaly',METHOD=>'delete'}
Updating all regions with the new schema...
1/1 regions updated.
Done.
0 row(s) in 3.0220 seconds

hbase(main):018:0> describe 'table'
Table table is ENABLED
table
COLUMN FAMILIES DESCRIPTION
{NAME => 'column_famaly1', 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 => 'column_famaly2', 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'}
2 row(s) in 0.0520 seconds

5.drop一个表

hbase(main):019:0> drop 'stu'

ERROR: Table stu 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

6.把表设置为disable

hbase(main):020:0> disable 'stu'
0 row(s) in 2.3150 seconds

再删除一个表
hbase(main):021:0> drop 'stu'
0 row(s) in 1.2820 seconds

列出所有表
hbase(main):022:0> list
TABLE
table
test
2 row(s) in 0.0240 seconds

=> ["table", "test"]

7.查询表是否存在

hbase(main):023:0> exists 'stu'
Table stu does not exist
0 row(s) in 0.0380 seconds

hbase(main):024:0> exists 'table'
Table table does exist
0 row(s) in 0.0280 seconds

8.判断表是否enable

hbase(main):025:0> is_enabled 'table'
true
0 row(s) in 0.0150 seconds

9.判断表是否disable

hbase(main):026:0> is_disabled 'table'
false
0 row(s) in 0.0140 seconds

把表设为disable
hbase(main):027:0> disable 'table'
0 row(s) in 33.2980 seconds

hbase(main):028:0> is_disabled 'table'
true
0 row(s) in 0.0140 seconds

三、DML操作

1.插入几条记录

hbase(main):029:0> put 'table','id','column_famaly1:name','tanggao'

ERROR: Failed 1 action: NotServingRegionException: 1 time,

Here is some help for this command:
Put a cell 'value' at specified table/row/column and optionally
timestamp coordinates. To put a cell value into table 'ns1:t1' or 't1'
at row 'r1' under column 'c1' marked with the time 'ts1', do:

hbase> put 'ns1:t1', 'r1', 'c1', 'value'
hbase> put 't1', 'r1', 'c1', 'value'
hbase> put 't1', 'r1', 'c1', 'value', ts1
hbase> put 't1', 'r1', 'c1', 'value', {ATTRIBUTES=>{'mykey'=>'myvalue'}}
hbase> put 't1', 'r1', 'c1', 'value', ts1, {ATTRIBUTES=>{'mykey'=>'myvalue'}}
hbase> put 't1', 'r1', 'c1', 'value', ts1, {VISIBILITY=>'PRIVATE|SECRET'}

The same commands also can be run on a table reference. Suppose you had a reference
t to table 't1', the corresponding command would be:

hbase> t.put 'r1', 'c1', 'value', ts1, {ATTRIBUTES=>{'mykey'=>'myvalue'}}

报错了,因为要把表设为enable
hbase(main):030:0> enable 'table'
0 row(s) in 1.3620 seconds

插入几条记录
hbase(main):031:0> put 'table','id','column_famaly1:name','tanggao'
0 row(s) in 0.0460 seconds

hbase(main):032:0> put 'table','id','column_famaly1:age','20'
0 row(s) in 0.0150 seconds

hbase(main):033:0> put 'table','id','column_famaly1:sex','boy'
0 row(s) in 0.0190 seconds

2.获取一条数据

获取一个id的所有数据

hbase(main):034:0> get 'table','id'
COLUMN CELL
column_famaly1:age timestamp=1463055735107, value=20
column_famaly1:name timestamp=1463055709542, value=tanggao
column_famaly1:sex timestamp=1463055753395, value=boy
3 row(s) in 0.3200 seconds

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

hbase(main):035:0> get 'table','id','column_famaly1'
COLUMN CELL
column_famaly1:age timestamp=1463055735107, value=20
column_famaly1:name timestamp=1463055709542, value=tanggao
column_famaly1:sex timestamp=1463055753395, value=boy
3 row(s) in 0.0270 seconds

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

hbase(main):036:0> get 'table','id','column_famaly1:name'
COLUMN CELL
column_famaly1:name timestamp=1463055709542, value=tanggao
1 row(s) in 0.0140 seconds

3.更新一条记录

把id的age修改为22
hbase(main):037:0> put 'table','id','column_famaly1:age','22'
0 row(s) in 0.0160 seconds

hbase(main):038:0> get 'table','id','column_famaly1:age'
COLUMN CELL
column_famaly1:age timestamp=1463055893492, value=22
1 row(s) in 0.0190 seconds

4.通过timestamp来获取两个版本的数据

hbase(main):039:0> get 'table','id',{COLUMN=>'column_famaly1:age',TIMESTAMP=>1463055735107}
COLUMN CELL
column_famaly1:age timestamp=1463055735107, value=20
1 row(s) in 0.0340 seconds

hbase(main):040:0> get 'table','id',{COLUMN=>'column_famaly1:age',TIMESTAMP=>1463055893492}
COLUMN CELL
column_famaly1:age timestamp=1463055893492, value=22
1 row(s) in 0.0140 seconds

5.全表扫描

hbase(main):041:0> scan 'table'
ROW COLUMN+CELL
id column=column_famaly1:age, timestamp=1463055893492, value=
22
id column=column_famaly1:name, timestamp=1463055709542, value
=tanggao
id column=column_famaly1:sex, timestamp=1463055753395, value=
boy
1 row(s) in 0.1520 seconds

6.删除行健为id的值的‘column_famaly1:age’字段

hbase(main):042:0> delete 'table','id','column_famaly1:age'
0 row(s) in 0.0200 seconds

hbase(main):043:0> get 'table','id'
COLUMN CELL
column_famaly1:name timestamp=1463055709542, value=tanggao
column_famaly1:sex timestamp=1463055753395, value=boy
2 row(s) in 0.2430 seconds

7.删除整行

hbase(main):044:0> deleteall 'table','id'
0 row(s) in 0.0550 seconds

8.查询表中有多少行

hbase(main):045:0> count 'table'
0 row(s) in 0.0450 seconds

=> 0

再插入几条记录

hbase(main):046:0> put 'table','id','column_famaly1:age','20'
0 row(s) in 0.0160 seconds

hbase(main):047:0> put 'table','id','column_famaly1:name','tanggao'
0 row(s) in 0.0120 seconds

hbase(main):048:0> put 'table','id','column_famaly2:name','tanggao2'
0 row(s) in 0.0120 seconds

hbase(main):001:0> put 'table','id','column_famaly2:age','22'
0 row(s) in 0.4690 seconds

9.给‘id’这个行健增加'column_famaly1:addr'字段，并使用counter实现递增

hbase(main):002:0> incr 'table','id','column_famaly1:addr'
COUNTER VALUE = 1
0 row(s) in 0.0340 seconds

hbase(main):003:0> incr 'table','id','column_famaly1:addr'
COUNTER VALUE = 2
0 row(s) in 9.6250 seconds

hbase(main):004:0> get 'table','id','column_famaly1:addr'
COLUMN CELL
column_famaly1:addr timestamp=1463056705124, value=\x00\x00\x00\x00\x00\x00\x0
0\x02
1 row(s) in 0.3930 seconds

hbase(main):005:0> incr 'table','id','column_famaly1:addr'
COUNTER VALUE = 3
0 row(s) in 7.3880 seconds

10.获取当前count的值

hbase(main):006:0> get_counter 'table','id','column_famaly1:addr'
COUNTER VALUE = 3

11.将整张表清空

hbase(main):007:0> truncate 'table'
Truncating 'table' table (it may take a while):
- Disabling table...
- Truncating table...
0 row(s) in 4.1510 seconds

hbase(main):008:0>

进入hbase shell console
$HBASE_HOME/bin/hbase shell
如果有kerberos认证，需要事先使用相应的keytab进行一下认证（使用kinit命令），认证成功之后再使用hbase shell进入可以使用whoami命令可查看当前用户
hbase(main)>whoami
表的管理
1）查看有哪些表
hbase(main)> list
2）创建表
# 语法：create <table>, {NAME => <family>, VERSIONS => <VERSIONS>}
# 例如：创建表t1，有两个family name：f1，f2，且版本数均为2
hbase(main)> create 't1',{NAME => 'f1', VERSIONS => 2},{NAME => 'f2', VERSIONS => 2}
3）删除表
分两步：首先disable，然后drop
例如：删除表t1
hbase(main)> disable 't1'
hbase(main)> drop 't1'
4）查看表的结构
# 语法：describe <table>
# 例如：查看表t1的结构
hbase(main)> describe 't1'
5）修改表结构
修改表结构必须先disable
# 语法：alter 't1', {NAME => 'f1'}, {NAME => 'f2', METHOD => 'delete'}
# 例如：修改表test1的cf的TTL为180天
hbase(main)> disable 'test1'
hbase(main)> alter 'test1',{NAME=>'body',TTL=>'15552000'},{NAME=>'meta', TTL=>'15552000'}
hbase(main)>enable 'test1'
权限管理
1）分配权限
# 语法 : grant <user> <permissions> <table> <column family> <column qualifier> 参数后面用逗号分隔
# 权限用五个字母表示： "RWXCA".
# READ('R'), WRITE('W'), EXEC('X'), CREATE('C'), ADMIN('A')
# 例如，给用户‘test'分配对表t1有读写的权限，
hbase(main)> grant 'test','RW','t1'
2）查看权限
# 语法：user_permission <table>
# 例如，查看表t1的权限列表
hbase(main)> user_permission 't1'
3）收回权限
# 与分配权限类似，语法：revoke <user> <table> <column family> <column qualifier>
# 例如，收回test用户在表t1上的权限
hbase(main)> revoke 'test','t1'
表数据的增删改查
1）添加数据
# 语法：put <table>,<rowkey>,<family:column>,<value>,<timestamp>
# 例如：给表t1的添加一行记录：rowkey是rowkey001，family name：f1，column name：col1，value：value01，timestamp：系统默认
hbase(main)> put 't1','rowkey001','f1:col1','value01'
用法比较单一。
2）查询数据
a）查询某行记录
# 语法：get <table>,<rowkey>,[<family:column>,....]
# 例如：查询表t1，rowkey001中的f1下的col1的值
hbase(main)> get 't1','rowkey001','f1:col1'
# 或者：
hbase(main)> get 't1','rowkey001', {COLUMN=>'f1:col1'}
# 查询表t1，rowke002中的f1下的所有列值
hbase(main)> get 't1','rowkey001'
b）扫描表
# 语法：scan <table>, {COLUMNS => [ <family:column>,.... ], LIMIT => num}
# 另外，还可以添加STARTROW、TIMERANGE和FITLER等高级功能
# 例如：扫描表t1的前5条数据
hbase(main)> scan 't1',{LIMIT=>5}
c）查询表中的数据行数
# 语法：count <table>, {INTERVAL => intervalNum, CACHE => cacheNum}
# INTERVAL设置多少行显示一次及对应的rowkey，默认1000；CACHE每次去取的缓存区大小，默认是10，调整该参数可提高查询速度
# 例如，查询表t1中的行数，每100条显示一次，缓存区为500
hbase(main)> count 't1', {INTERVAL => 100, CACHE => 500}
3）删除数据
a )删除行中的某个列值
# 语法：delete <table>, <rowkey>, <family:column> , <timestamp>,必须指定列名
# 例如：删除表t1，rowkey001中的f1:col1的数据
hbase(main)> delete 't1','rowkey001','f1:col1'
注：将删除改行f1:col1列所有版本的数据
b )删除行
# 语法：deleteall <table>, <rowkey>, <family:column> , <timestamp>，可以不指定列名，删除整行数据
# 例如：删除表t1，rowk001的数据
hbase(main)> deleteall 't1','rowkey001'
c）删除表中的所有数据
# 语法： truncate <table>
# 其具体过程是：disable table -> drop table -> create table
# 例如：删除表t1的所有数据
hbase(main)> truncate 't1'
Region管理
1）移动region
# 语法：move 'encodeRegionName', 'ServerName'
# encodeRegionName指的regioName后面的编码，ServerName指的是master-status的Region Servers列表
# 示例
hbase(main)>move'4343995a58be8e5bbc739af1e91cd72d','db-41.xxx.xxx.org,60020,1390274516739'
2）开启/关闭region
# 语法：balance_switch true|false
hbase(main)> balance_switch
3）手动split
# 语法：split 'regionName', 'splitKey'
4）手动触发major compaction
#语法：
#Compact all regions in a table:
#hbase> major_compact 't1'
#Compact an entire region:
#hbase> major_compact 'r1'
#Compact a single column family within a region:
#hbase> major_compact 'r1', 'c1'
#Compact a single column family within a table:
#hbase> major_compact 't1', 'c1'
配置管理及节点重启
1）修改hdfs配置
hdfs配置位置：/etc/hadoop/conf
# 同步hdfs配置
cat /home/hadoop/slaves|xargs -i -t scp /etc/hadoop/conf/hdfs-site.xml hadoop@{}:/etc/hadoop/conf/hdfs-site.xml
#关闭：
cat /home/hadoop/slaves|xargs -i -t ssh hadoop@{}"sudo /home/hadoop/cdh4/hadoop-2.0.0-cdh4.2.1/sbin/hadoop-daemon.sh --config /etc/hadoop/conf stop datanode"
#启动：
cat /home/hadoop/slaves|xargs -i -t ssh hadoop@{}"sudo /home/hadoop/cdh4/hadoop-2.0.0-cdh4.2.1/sbin/hadoop-daemon.sh --config /etc/hadoop/conf start datanode"
2）修改hbase配置
hbase配置位置：
# 同步hbase配置
cat /home/hadoop/hbase/conf/regionservers|xargs -i -t scp /home/hadoop/hbase/conf/hbase-site.xml hadoop@{}:/home/hadoop/hbase/conf/hbase-site.xml

# graceful重启
cd ~/hbase
bin/graceful_stop.sh --restart --reload --debug inspurXXX.xxx.xxx.org

阅读全文

1 0