Hbase基本操作

 

#建表

hbase(main):001:0> create 'hbase_test',  {NAME=>'cf1'},{NAME=>'cf2'}

0 row(s) in 1.4630 seconds

 

#插入数据

hbase(main):002:0> put'hbase_test', '002','cf1:name','jack'

0 row(s) in 0.1300 seconds

 

#查询数据

hbase(main):003:0> scan 'hbase_test'

ROW                                                COLUMN+CELL                                                                                                                                      

001                                               column=cf1:name, timestamp=1545377040731, value=Tom                                                                                              

1 row(s) in 0.0250 seconds

 

#生成快照

hbase(main):001:0> snapshot 'hbase_test','hbase_test-Snapshot-1222'

0 row(s) in 0.3180 seconds

 

#截断该表

hbase(main):003:0> truncate 'hbase_test'

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

- Disabling table...

- Truncating table...

0 row(s) in 3.3980 seconds

 

         

#禁用该表                                                                                     

hbase> disable 'hbase_test'

  

#从快照恢复数据

hbase> restore_snapshot'myTableSnapshot-1222'

 

#启用该表

hbase> enable 'hbase_test'

 

 

--进阶操作

登录hbase库   

[root@gx-test-hadoop01 ~]# hbase shell

 

查看所有表

hbase(main):002:0* list   

 

get 'test', 'row1'

 

生成快照：

hbase> snapshot 'AD_HOMEPAGE','AD_HOMEPAGE-Snapshot-1220'

 

列出当前所有得快照：

hbase> list_snapshots

 

删除快照信息：

hbase> delete_snapshot'myTableSnapshot-122112'

 

基于快照，clone一个新表：

hbase> clone_snapshot'myTableSnapshot-122112', 'myNewTestTable'

 

基于快照恢复表：

hbase> disable 'myTable'

hbase> restore_snapshot'myTableSnapshot-122112'

 

hbase> disable 'hbase_test'

hbase> restore_snapshot 'hbase_test-Snapshot-1221'

hbase> enable 'hbase_test'

 

 

 

 

导出到另外一个集群中：

$bin/hbase class org.apache.hadoop.hbase.snapshot.tool.ExportSnapshot -snapshotMySnapshot -copy-to hdfs:///srv2:8082/hbase -mappers 16