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