Hbase简单操作

进入hbase shell后的一些简单操作

1、status 可以查看当前hadoop的文件系统情况：

1 servers, 0 dead, 2.0000 average load

2、version可以查看hbase的版本

3、创建一张表  create 'member','member_id','address','info'

4、查看当前有多少表  list

5、查看制定表的结构情况  desceibe '表名'：

hbase(main):006:0> describe 'member'
Table member is ENABLED                                                         
COLUMN FAMILIES DESCRIPTION                                                     
{NAME => 'address', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICA
TION_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', REPLICATIO
N_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0', TTL
 => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY =>
 'false', BLOCKCACHE => 'true'}                                                 
{NAME => 'member_id', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLI
CATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSIONS => '0'
, TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMO
RY => 'false', BLOCKCACHE => 'true'}                                            
3 row(s) in 0.0270 seconds

6、删除列族 alter disable enale

在改变表之前先要disable member离线            然后在使用enable member

 alter 'member',{NAME=>'member_id',METHOD=>'delete'}
Updating all regions with the new schema...
0/1 regions updated.
1/1 regions updated.
Done.

7、删除表  drop '表名'

8、判断表是否存在 exists ‘表名’

9、判断一个表是在线还是离线 is_enabled '表名'    is_disabled '表名'

10、向表插入数据使用put，会加入时间戳
put 'member','scutshuxue','address:contry','china'=================》向member表中插入scutshuxue这个人，address是刚才的列族，加入country列，赋值china

'put 'member','xiaonan','info:age','23'

 put 'member','xiaonan','info:birthday','1993-09-25'

11、获取一个行健的所有数据，使用get，   get 'member','scutshuxue'：

COLUMN                CELL                                                      
 address:contry       timestamp=1472887924772, value=china                      
 address:province     timestamp=1472887938633, value=hangzhou                   
 info:age             timestamp=1472887868607, value=24                         
 info:birthday        timestamp=1472887887290, value=1993-05-17                 
 info:company         timestamp=1472887901407, value=alibaba             

    还可以指定一个列族get 'member','scutshuxue',‘info’

'info' info:age            timestamp=1472887868607, value=24                         
 info:birthday        timestamp=1472887887290, value=1993-05-17                 
 info:company         timestamp=1472887901407, value=alibaba    

     还可以指定一个列族的一个列get 'member','scutshuxue','info:age'
 info:age             timestamp=1472887868607, value=24     

12、更新一条记录，跟插入一个put，便能进行修改

13、可以通过时间戳来获取数据TIMESTAMP=>

14、全表扫描 scan ‘表名’，列出表的全部结果

15、删除指定行健的字段 delete '表名','行健'，'列'   delete 'member','scutshuxue','info:birthday'

      deleteall '表名'，'行健' 可以删除行健指定的

16、查询表中有多少行 count '表名'

17、清空表，truncate '表名'===》实际过程是先离线，再drop，然后再新建