Hbase的基本操作

Hbase

开启hbase需要先要打开hadoop，start-all.sh

开启zookeeper集群zkServer.sh start

开启start-hbase，

进入shell : hbase shell

查看版本

hbase(main):001:0> version

查看所有库：hbase(main):018:0> list_namespace

建库：hbase(main):001:0>create_namespace 'kb15'

建表，不写库名会建在默认库：第一种： hbase(main):018:0>create 'hbase:student',{NAME=>'base_info'},{NAME=>'teacher_info'},{NAME=>'student_info'} 

第二种： hbase(main):018:0>create  'hbase:student','base_info','class_info','other_info'

查看指定库中所有表：hbase(main):003:0> list_namespace_tables "hbase"

查看所有表，并有库名，没有的时默认库：hbase(main):022:0> list

hbase(main):044:0> list

TABLE                                                                        

kb15:student                                                                 

nanjing:teacher                                                              

student                                                                      

students                                                                     

4 row(s) in 0.0060 seconds

=> ["kb15:student", "nanjing:teacher", "student", "students"]

删除表需要先禁用：hbase(main):040:0> disable 'default:students'

删除表：hbase(main):041:0>  drop 'default:students'

删除namespace：hbase(main):012:0> drop_namespace 'lijia'

查询表结构：hbase(main):016:0> describe 'gree:student'

插入语句，取字段名：hbase(main):031:0> put 'kb15:student','rowkey2','base_info:name','jack'

查询：hbase(main):026:0> get 'gree:student','rowkey1','baseInfo'

COLUMN                    CELL                                                                    

baseInfo:age             timestamp=1637287937682, value=32                                       

baseInfo:birthday        timestamp=1637287837416, value=1989-01-01                               

baseInfo:name            timestamp=1637287603055, value=tom                                      

3 row(s) in 0.0040 seconds

hbase(main):027:0> get 'gree:student','rowkey1','schoolInfo'

COLUMN                    CELL                                                                    

schoolInfo:name          timestamp=1637288031855, value=njzb                                     

1 row(s) in 0.0030 seconds

hbase(main):026:0> get 'gree:student','rowkey1','baseInfo:name'

退出

hbase(main):014:0> exit