错误的方式：

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

Updating all regions with the newschema...

0/1 regions updated.

1/1 regions updated.

Done.

0 row(s) in 2.2130 seconds

正确的方式：修改表结构之前先disable

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

0 row(s) in 1.2830 seconds

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

Updating all regions with the newschema...

1/1 regions updated.

Done.

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

0 row(s) in 0.4320 seconds

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

Table member is ENABLED

member

COLUMN FAMILIES DESCRIPTION

{NAME => 'address', DATA_BLOCK_ENCODING=> 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS=> '1', COMPR

ESSION => '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', COMPRESS

ION => 'NONE', MIN_VERSIONS => '0',TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536',IN_MEMORY => '

false', BLOCKCACHE => 'true'}

2 row(s) in 0.0300 seconds

可以看到只有两个列族了。

6） 表操作

a） 删除表

hbase(main):027:0>create 'temp_table','table'

0 row(s) in 0.4420 seconds

=> Hbase::Table - temp_table

?

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

0 row(s) in 1.2190 seconds

?

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

0 row(s) in 0.1890seconds

b） 查看表是否存在

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

Table member does exist

0 row(s) in 0.0120seconds

c） 判断表是否是enable或disable

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

true

0 row(s) in 0.0190 seconds

?

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

false

0 row(s) in 0.0220seconds

d） 插入记录

hbase(main):049:0>put'member','xueba','info:age','25'

注释：member指表名,xueba指行键,作为查找数据的键

info:age指列族info中的一个列，值value为25

put'member','xueba','info:birthday','1989-06-19'

put'member','xueba','info:company','tecent'

put'member','xueba','address:country','china'

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

put'member','xueba','address:city','shenzhen'

?

上面其实就一行数据，行键为xueba

下面再插入一行，行键为xiaoming:

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

put 'member','xiaoming','info:birthday','1990-03-22'

put'member','xiaoming','info:company','tecent'

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

put'member','xiaoming','address:country','china'

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

put 'member','xiaoming','address:city','guangzhou'

?

e） 获取数据

hbase(main):065:0>get'member','xueba'

COLUMN CELL

address:city timestamp=1434253878145, value=shenzhen

address:country timestamp=1434253848370,value=china

address:province timestamp=1434253860038,value=guangdong

info:age timestamp=1434253655367, value=25

info:birthday timestamp=1434253816609, value=1989-06-19

info:company timestamp=1434253830724, value=tecent

6 row(s) in0.1420 seconds

?

hbase(main):066:0>get'member','xiaoming','info'

COLUMN CELL

info:age timestamp=1434253975698,value=24

info:birthday timestamp=1434253997664,value=1990-03-22

info:company timestamp=1434254011707,value=tecent

info:favorite timestamp=1434254024140,value=movie

4 row(s) in0.0700 seconds

?