如何修改hbase中的表名

骑猪看日落 2022-06-02 03:40 737阅读 0赞

hbase中没有rename，所以改表名要很复杂，重命名主要通过hbase的快照功能来实现。具体步骤如下————  
  
【1. 停用表，防止继续插入】  
hbase(main):007:0> disable 'your\_namespace:test\_zzz'  
hbase(main):006:0> count 'your\_namespace:test\_zzz', INTERVAL => 100000   \# 记住这个记录数为200条  
200 row(s) in 0.0750 seconds  
=> 200  
  
  
【2.制作快照】  
hbase(main):010:0> snapshot 'your\_namespace:test\_zzz', 'tony\_snapshot' \# 默认会将memStore的数据刷到磁盘中  
0 row(s) in 0.4220 seconds  
  
  
【3.克隆快照为新的名字（这一步实现改名）】  
\# 把表test\_zzz改名为weekly\_active\_users  
hbase(main):013:0> clone\_snapshot 'tony\_snapshot', **'your\_namespace:weekly\_active\_users'**  
hbase(main):014:0> list\_namespace\_tables 'your\_namespace'  
TABLE  
test\_zzz  
**weekly\_active\_users**  
good\_boy\_tony  
nice\_guys  
4 row(s) in 0.0400 seconds  
  
\# 检查更名之后的表和更名之前的表是否一致  
hbase(main):015:0> count 'your\_namespace:weekly\_active\_users'  
200 row(s) in 0.3320 seconds  
=> 200  
  
  
【4. 成功改完名以后，删除快照】  
hbase(main):016:0> list\_snapshots  
SNAPSHOT TABLE + CREATION TIME  
 tony\_snapshot your\_namespace:test\_zzz (Tue Jan 02 16:30:10 +0800 2018)  
1 row(s) in 0.0950 seconds  
=> \["tony\_snapshot"\]  
  
\# 删除快照  
hbase(main):017:0> delete\_snapshot 'tony\_snapshot'  
0 row(s) in 0.0590 seconds  
  
\# 检查原来的表和改名后的表状态是否一致  
hbase(main):019:0> desc 'your\_namespace:test\_zzz'   \# 改名以前的表状态  
Table your\_namespace:test\_zzz is DISABLED  
your\_namespace:test\_zzz  
COLUMN FAMILIES DESCRIPTION  
\{NAME => 'cf1', BLOOMFILTER => 'NONE', VERSIONS => '3', IN\_MEMORY => 'false', KEEP\_DELETED\_CELLS => 'FALSE', DATA\_BLOCK\_ENCODING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN\_VERSIONS => '0', BLOCKCACHE => 'false', BLOCKSIZE => '65536', REPLICATION\_SCOPE => '0  
'\}  
\{NAME => 'cf2', BLOOMFILTER => 'NONE', VERSIONS => '3', IN\_MEMORY => 'false', KEEP\_DELETED\_CELLS => 'FALSE', DATA\_BLOCK\_ENCODING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN\_VERSIONS => '0', BLOCKCACHE => 'false', BLOCKSIZE => '65536', REPLICATION\_SCOPE => '0  
'\}  
2 row(s) in 0.0540 seconds  
  
\# 改名以后的表状态 ——— 自动enable了  
hbase(main):022:0> desc 'your\_namespace:weekly\_active\_users'

Table your\_namespace:weekly\_active\_users is ENABLED

your\_namespace:weekly\_active\_users

COLUMN FAMILIES DESCRIPTION  
\{NAME => 'cf1', BLOOMFILTER => 'NONE', VERSIONS => '3', IN\_MEMORY => 'false', KEEP\_DELETED\_CELLS => 'FALSE', DATA\_BLOCK\_ENCODING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN\_VERSIONS => '0', BLOCKCACHE => 'false', BLOCKSIZE => '65536', REPLICATION\_SCOPE => '0  
'\}  
\{NAME => 'cf2', BLOOMFILTER => 'NONE', VERSIONS => '3', IN\_MEMORY => 'false', KEEP\_DELETED\_CELLS => 'FALSE', DATA\_BLOCK\_ENCODING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN\_VERSIONS => '0', BLOCKCACHE => 'false', BLOCKSIZE => '65536', REPLICATION\_SCOPE => '0  
'\}   
2 row(s) in 0.0450 seconds  
\# 可以看出，改名前后的表列簇、列，以及表的各项配置都是一样的  
  
  
【5. 改名完成后，删除原来的表】

hbase(main):020:0> disable "your\_namespace:test\_zzz'  
0 row(s) in 1.7820 seconds

hbase(main):020:0> drop 'your\_namespace:test\_zzz'

0 row(s) in 1.3650 seconds  
  
\# test\_zzz表已被删除  
hbase(main):021:0> list\_namespace\_tables 'ksai'  
TABLE

weekly\_active\_users

good\_boy\_tony

nice\_guys  
3 row(s) in 0.0210 seconds  
  
完成。