[Hbase] Hbase shell 操作数据

• 清空表

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

• 查看表

hbase(main):049:0> desc 'tmp'
Table tmp is ENABLED                                                                                                              
tmp                                                                                                                               
COLUMN FAMILIES DESCRIPTION                                                                                                       
{NAME => 'add', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => 
'1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE 
=> 'true'}                                                                                                                        
{NAME => 'col1', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'N
ONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE
 => 'true'}                                                                                                                       
{NAME => 'col2', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'N
ONE', MIN_VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE
 => 'true'}                                                                                                                       
{NAME => 'col3', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS =>
 '1', TTL => 'FOREVER', MIN_VERSIONS => '0', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE
 => 'true'}                                                                                                                       
4 row(s) in 0.0510 seconds

• 插入数据

hbase(main):050:0> put 'tmp','1','col2:birthday','1989'
0 row(s) in 0.2730 seconds

hbase(main):051:0> put 'tmp','1','col2:sex','M'
0 row(s) in 0.0170 seconds

hbase(main):052:0> put 'tmp','1','col2:edu','Master'
0 row(s) in 0.0150 seconds

• 获取数据

hbase(main):053:0> get 'tmp','1'
COLUMN                            CELL                                                                                            
 col2:birthday                    timestamp=1474960341032, value=1989                                                             
 col2:edu                         timestamp=1474960391040, value=Master                                                           
 col2:sex                         timestamp=1474960365538, value=M                                                                
3 row(s) in 0.0440 seconds

• 插入数据

hbase(main):054:0> put 'tmp','1','col3:province','HeNan'
0 row(s) in 0.0160 seconds

hbase(main):055:0> put 'tmp','1','col3:city','AnYang'
0 row(s) in 0.0200 seconds

hbase(main):056:0> put 'tmp','1','col3:country','China'
0 row(s) in 0.0260 seconds

• 获取数据

hbase(main):057:0> get 'tmp','1'
COLUMN                            CELL                                                                                            
 col2:birthday                    timestamp=1474960341032, value=1989                                                             
 col2:edu                         timestamp=1474960391040, value=Master                                                           
 col2:sex                         timestamp=1474960365538, value=M                                                                
 col3:city                        timestamp=1474960445073, value=AnYang                                                           
 col3:country                     timestamp=1474960469793, value=China                                                            
 col3:province                    timestamp=1474960428960, value=HeNan                                                            
6 row(s) in 0.0290 seconds

• 获取某一列的数据

hbase(main):058:0> get 'tmp','1','col2'
COLUMN                            CELL                                                                                            
 col2:birthday                    timestamp=1474960341032, value=1989                                                             
 col2:edu                         timestamp=1474960391040, value=Master                                                           
 col2:sex                         timestamp=1474960365538, value=M                                                                
3 row(s) in 0.0250 seconds

• 扫描整张表

hbase(main):059:0> scan 'tmp'
ROW                               COLUMN+CELL                                                                                     
 1                                column=col2:birthday, timestamp=1474960341032, value=1989                                       
 1                                column=col2:edu, timestamp=1474960391040, value=Master                                          
 1                                column=col2:sex, timestamp=1474960365538, value=M                                               
 1                                column=col3:city, timestamp=1474960445073, value=AnYang                                         
 1                                column=col3:country, timestamp=1474960469793, value=China                                       
 1                                column=col3:province, timestamp=1474960428960, value=HeNan                                      
1 row(s) in 0.0380 seconds

• 取某列族的某个值

hbase(main):060:0> get 'tmp','1','col2:edu'
COLUMN                                     CELL                                                                                                                     
 col2:edu                                  timestamp=1474960391040, value=Master                                                                                    
1 row(s) in 0.0180 seconds

• 修改数据

hbase(main):061:0> put 'tmp','1','col2:birthday','1990'
0 row(s) in 0.0210 seconds

hbase(main):062:0> scan 'tmp'
ROW                                        COLUMN+CELL                                                                                                              
 1                                         column=col2:birthday, timestamp=1474960599264, value=1990                                                                
 1                                         column=col2:edu, timestamp=1474960391040, value=Master                                                                   
 1                                         column=col2:sex, timestamp=1474960365538, value=M                                                                        
 1                                         column=col3:city, timestamp=1474960445073, value=AnYang                                                                  
 1                                         column=col3:country, timestamp=1474960469793, value=China                                                                
 1                                         column=col3:province, timestamp=1474960428960, value=HeNan                                                               
1 row(s) in 0.0460 seconds

hbase(main):063:0> get 'tmp','1','col2:birthday'
COLUMN                                     CELL                                                                                                                     
 col2:birthday                             timestamp=1474960599264, value=1990                                                                                      
1 row(s) in 0.0170 seconds

• 删除数据

hbase(main):064:0> delete 'tmp','1','col2'
0 row(s) in 0.0700 seconds

hbase(main):065:0> scan 'tmp'
ROW                                        COLUMN+CELL                                                                                                              
 1                                         column=col2:birthday, timestamp=1474960599264, value=1990                                                                
 1                                         column=col2:edu, timestamp=1474960391040, value=Master                                                                   
 1                                         column=col2:sex, timestamp=1474960365538, value=M                                                                        
 1                                         column=col3:city, timestamp=1474960445073, value=AnYang                                                                  
 1                                         column=col3:country, timestamp=1474960469793, value=China                                                                
 1                                         column=col3:province, timestamp=1474960428960, value=HeNan                                                               
1 row(s) in 0.0300 seconds

hbase(main):066:0> delete 'tmp','1','col2:birthday'
0 row(s) in 0.0170 seconds

hbase(main):067:0> scan 'tmp'
ROW                                        COLUMN+CELL                                                                                                              
 1                                         column=col2:edu, timestamp=1474960391040, value=Master                                                                   
 1                                         column=col2:sex, timestamp=1474960365538, value=M                                                                        
 1                                         column=col3:city, timestamp=1474960445073, value=AnYang                                                                  
 1                                         column=col3:country, timestamp=1474960469793, value=China                                                                
 1                                         column=col3:province, timestamp=1474960428960, value=HeNan                                                               
1 row(s) in 0.0330 seconds

• 删除某一种

hbase(main):068:0> deleteall 'tmp','1'
0 row(s) in 0.0150 seconds

hbase(main):069:0> scan 'tmp'
ROW                                        COLUMN+CELL                                                                                                              
0 row(s) in 0.0270 seconds