Docker 安装HBase 并使用

ps:安装完成HBase后记得将docker 容器ID与ip配置到hosts文件，并重启网卡网络信息 

一.安装

1.创建docker-compose.yml文件

version: '3.1'
services:
  hbase:
    image: harisekhon/hbase:1.4.7
    container_name: hbase
    restart: always
    ports:
      - 8880:8080
      - 8885:8085
      - 9990:9090
      - 9995:9095
      - 16000:16000
      - 16010:16010
      - 16020:16020
      - 16030:16030
      - 16201:16201
      - 16301:16301
      - 2381:2181
    environment:
      # SERVICE_PRECONDITION: "namenode:50070 datanode:50075"
      - TZ="Asia/Shanghai"
      - LANG=en_US.UTF-8
    volumes:
      - ./hbase_data:/hbase-data
      - ./hbase_zookeeper_data:/zookeeper-data
networks:
  default:
    driver: bridge

使用docker-compose命令运行：

docker-compose up -d 

2.修改配置文件

  (1).修改hbase-site.xml配置文件
    hbase.rootdir  修改成  hbase.root.dir
  (2).在hbase-env.sh里面添加

export HBASE_DISABLE_HADOOP_CLASSPATH_LOOKUP=true

 (3).重启hbase即可

二.使用

1.建表

//创建命名空间
create_namespace 'user'
//创建表				
create 'user:sac','student','course1','course2','course3'     

2.插入数据

//第一条
put 'user:sac','2015001','student:S_Name','zhangsan'
put 'user:sac','2015001','student:S_Sex','male'
put 'user:sac','2015001','student:S_Age','23'
put 'user:sac','2015001','course1:C_No','123001'
put 'user:sac','2015001','course1:C_Name','Math'
put 'user:sac','2015001','course1:C_Credit','2.0'
put 'user:sac','2015001','course1:Score','86'
put 'user:sac' ,'2015001','course3:C_No','123003'
put 'user:sac' ,'2015001','course3:C_Name','English'
put 'user:sac' ,'2015001','course3:C_Credit','3.0'
put 'user:sac' ,'2015001','course3:Score','69'
//第二条
put 'user:sac' ,'2015002','student:S_Name','lisi'
put 'user:sac' ,'2015002','student:S_Sex','female'
put 'user:sac' ,'2015002','student:S_Age','22'
put 'user:sac' ,'2015002','course2:C_No','123002'
put 'user:sac' ,'2015002','course2:C_Name','Conputer Science'
put 'user:sac' ,'2015002','course2:Credit','5.0'
put "user:sac" ,'2015002','course2:Score','77'
put 'user:sac' ,'2015002','course3:C_No','123003'
put 'user:sac' ,'2015002','course3:C_Name','English'
put 'user:sac' ,'2015002','course3:Credit','3.0'
put 'user:sac' ,'2015002','course3:Score','99'
//第三条
put 'user:sac' ,'2015003','student:S_Name','wanger'
put 'user:sac' ,'2015003','student:S_Sex','male'
put 'user:sac' ,'2015003','student:S_Age','24'
put 'user:sac' ,'2015003','course1:C_No','123001'
put 'user:sac' ,'2015003','course1:C_Name','Math'
put 'user:sac' ,'2015003','course1:C_Credit','2.0'
put 'user:sac' ,'2015003','course1:Score','98'
put 'user:sac' ,'2015003','course2:C_No','123002'
put 'user:sac' ,'2015003','course2:C_Name','Computer Science'
put 'user:sac' ,'2015003','course2:C_Credit','5.0'
put 'user:sac' ,'2015003','course2:Score','95'

3.查询

(1).查询命名空间列表  

//show databases;
list_namespace

(2).查询命名空间(database)下的表  

//show tables;
list_namespace_tables 'namespace'

(3).全表查询  

//select * from tableName
scan 'namespace:table'

(4).全表扫面指定的族(根据表下的某个族查询)  

在nosql中存储数据是将某个对象所有的属性全部存储
例如关系型数据库中的用户，权限，角色是分表存储，但是nosql中，将某个用户的权限角色都一起存在用户表中;
其中用户，角色，权限分别属于用户表中的三个族
  
scan 'namespace:table',COLUMn=>'用户族'

(5).查询某个族下的指定列的数据

//查询唯一一条 get
//根据条件查询某条数据
get 'namespace:table','rowkey','族:列'

//批量查询 scan
//查询从rowkeyStart到rowkeyStop的数据
scan 'namespace:table',{COLUMN=>'族',STARTROW=>'rowkeyStart',STOPROW=>'rowkeySTOP+1'} 
//查询10条数据
scan 'namespace:table',{COLUMN=>'族',LIMIT=>10}

(6).根据条件过滤查询
  scan 'namespace:table',FILTER=>"ColumnPrefixFilter('字段条件') AND ValueFilter(=,'substring:内容条件')"
  例:  

//在user库中查询，学生姓名列S_Name包含‘张’的数据
scan 'user:sac',FILTER=>"ColumnPrefixFilter('S_Name') AND ValueFilter(=,'substring:zhang')"

4.删除数据

(1).根据rowkey删除指定的行

//deleteall rowkey
deleteall '2015003'