使用Java API操作HBase

一、创建maven工程，并添加依赖包

<!-- https://mvnrepository.com/artifact/org.apache.hbase/hbase-client -->
    <dependency>
      <groupId>org.apache.hbase</groupId>
      <artifactId>hbase-client</artifactId>
      <version>1.2.0</version>
    </dependency>
<!-- https://mvnrepository.com/artifact/org.apache.hbase/hbase-common -->
    <dependency>
      <groupId>org.apache.hbase</groupId>
      <artifactId>hbase-common</artifactId>
      <version>1.2.0</version>
    </dependency>
<!-- https://mvnrepository.com/artifact/org.apache.hbase/hbase-server -->
    <dependency>
      <groupId>org.apache.hbase</groupId>
      <artifactId>hbase-server</artifactId>
      <version>1.2.0</version>
    </dependency>

二、创建hbase客户类进行测试

导包

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.*;
import org.apache.hadoop.hbase.client.*;
import org.apache.hadoop.hbase.util.Bytes;
import org.junit.Test;

import java.io.IOException;

创建表操作

@Test
    public void createTable() throws IOException {
        //1.创建配置
        Configuration conf= HBaseConfiguration.create();
        //配置zookeeper的集群端口
        conf.set("hbase.zookeeper.quorum","lyq");
        conf.set("hbase.zookeeper.property.clientPort","2181");
        //2.创建连接
        Connection conn= ConnectionFactory.createConnection(conf);
        //创建admin
        Admin admin = conn.getAdmin();
        //3.创建表的描述信息
        HTableDescriptor student = new HTableDescriptor(TableName.valueOf("student"));
        //4.添加列族
        student.addFamily(new HColumnDescriptor("info"));
        student.addFamily(new HColumnDescriptor("score"));
        //5.调用API进行建表操作
        admin.createTable(student);
    }

判断表是否存在

@Test
    public void isTableExists() throws IOException {
        //1.创建配置
        Configuration conf= HBaseConfiguration.create();
        //配置zookeeper的集群端口
        conf.set("hbase.zookeeper.quorum","lyq");
        conf.set("hbase.zookeeper.property.clientPort","2181");
        //2.创建连接
        Connection conn= ConnectionFactory.createConnection(conf);
        //3.创建admin
        Admin admin = conn.getAdmin();
        //4.调用API进行判断表是否存在
        System.out.println(admin.tableExists(TableName.valueOf("student2")));
    }

向表中插入数据

@Test
    public void putDataTable() throws IOException {
        //1.创建配置
        Configuration conf= HBaseConfiguration.create();
        //配置zookeeper的集群端口
        conf.set("hbase.zookeeper.quorum","lyq");
        conf.set("hbase.zookeeper.property.clientPort","2181");
        //2.创建连接
        Connection conn= ConnectionFactory.createConnection(conf);
        //3.创建Table类
        Table student = conn.getTable(TableName.valueOf("student"));
        //4.创建Put类
        Put put = new Put(Bytes.toBytes("1001"));
        //5.向Put中添加 列族，列名，值，注意：需要转化成字节数组
        put.addColumn(Bytes.toBytes("info"),Bytes.toBytes("name"),Bytes.toBytes("zhangsan"));
        put.addColumn(Bytes.toBytes("info"),Bytes.toBytes("sex"),Bytes.toBytes("female"));
        put.addColumn(Bytes.toBytes("score"),Bytes.toBytes("course"),Bytes.toBytes("math"));
        put.addColumn(Bytes.toBytes("score"),Bytes.toBytes("score"),Bytes.toBytes("90"));
        //调用API进行插入数据
        student.put(put);
    }

查看一条数据

@Test
    public void getDataTable() throws IOException {
        //1.创建配置
        Configuration conf= HBaseConfiguration.create();
        //配置zookeeper的集群端口
        conf.set("hbase.zookeeper.quorum","lyq");
        conf.set("hbase.zookeeper.property.clientPort","2181");
        //2.创建连接
        Connection conn= ConnectionFactory.createConnection(conf);
        //3.创建Table类
        Table student = conn.getTable(TableName.valueOf("student"));
        //4.创建Get类
        Get get=new Get(Bytes.toBytes("1001"));
        //5.调用API进行获取数据
        Result result=student.get(get);
        //6.将返回的结果进行遍历输出
        Cell[] cells=result.rawCells();
        for (Cell cell : cells) {
            System.out.println("rowkey:"+Bytes.toString(CellUtil.cloneRow(cell)));
            System.out.println("列族："+Bytes.toString(CellUtil.cloneFamily(cell)));
            System.out.println("列名："+Bytes.toString(CellUtil.cloneQualifier(cell)));
            System.out.println("值："+Bytes.toString(CellUtil.cloneValue(cell)));
            System.out.println("-----------------------");
        }
    }

删除表操作

@Test
    public void dropTable() throws IOException {
        //1.创建配置
        Configuration conf= HBaseConfiguration.create();
        //配置zookeeper的集群端口
        conf.set("hbase.zookeeper.quorum","lyq");
        conf.set("hbase.zookeeper.property.clientPort","2181");
        //2.创建连接
        Connection conn= ConnectionFactory.createConnection(conf);
        //3.创建admin
        Admin admin = conn.getAdmin();
        //4.调用API警用表
        admin.disableTable(TableName.valueOf("student"));
        //5.删除词表
        admin.deleteTable(TableName.valueOf("student"));
    }