HBase Basic Commands

1. Create a table

hbase(main):008:0* create 'userstable', 'columnfamily1'
0 row(s) in 1.8390 seconds

hbase(main):009:0> 

2. List tables

hbase(main):010:0> list
TABLE                                                                                                                   
userstable                                                                                                              
1 row(s) in 0.0270 seconds

hbase(main):011:0> 

3. Insert data

hbase(main):027:0> put 'userstable', 'adam', 'columnfamily1:age', '37'
0 row(s) in 0.0240 seconds

hbase(main):028:0> put 'userstable', 'smith', 'columnfamily1:jobtitle', 'economist'
0 row(s) in 0.0210 seconds

hbase(main):032:0> put 'userstable', 'smith', 'columnfamily1:zipcode', '12323'
0 row(s) in 0.0210 seconds

4. Retrieving data
Option-1

hbase(main):041:0* scan 'userstable'
ROW                             COLUMN+CELL                                                                             
 adam                           column=columnfamily1:age, timestamp=1346572453806, value=37                             
 smith                          column=columnfamily1:jobtitle, timestamp=1346572501886, value=economist                 
 smith                          column=columnfamily1:zipcode, timestamp=1346573300290, value=12323                      
2 row(s) in 0.0500 seconds

Option-2

hbase(main):043:0> get 'userstable', 'smith'
COLUMN                          CELL                                                                                    
 columnfamily1:jobtitle         timestamp=1346572501886, value=economist                                                
 columnfamily1:zipcode          timestamp=1346573300290, value=12323                                                    
2 row(s) in 0.0060 seconds

hbase(main):044:0> 

5. Delete rows

hbase(main):044:0> delete 'userstable', 'smith', 'columnfamily1:zipcode'
0 row(s) in 0.0270 seconds

hbase(main):045:0> get 'userstable', 'smith'
COLUMN                          CELL                                                                                    
 columnfamily1:jobtitle         timestamp=1346572501886, value=economist                                                
1 row(s) in 0.0310 seconds

hbase(main):046:0> 

3. Drop a table

hbase(main):005:0* disable 'userstable'
0 row(s) in 2.7900 seconds

hbase(main):006:0> drop 'userstable'
0 row(s) in 12.5980 seconds

hbase(main):007:0>