HBase API练习

DDL

判断表是否存在

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.HBaseConfiguration;
import org.apache.hadoop.hbase.TableName;
import org.apache.hadoop.hbase.client.Admin;
import org.apache.hadoop.hbase.client.Connection;
import org.apache.hadoop.hbase.client.ConnectionFactory;
import org.apache.hadoop.hbase.client.HBaseAdmin;

import java.io.IOException;

public class test {

    private static Connection connection = null;
    private static Admin admin = null;

    static{

        try {
            //1.获取配置文件信息
            Configuration configuration = HBaseConfiguration.create();
            configuration.set("hbase.zookeeper.quorum", "hadoop01,hadoop02,hadoop03");
            //2.创建链接对象
            connection = ConnectionFactory.createConnection(configuration);
            //3.创建Admin对象
            admin = connection.getAdmin();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }

    public static boolean isTableExist(String tableName) throws IOException {
        boolean exists = admin.tableExists(TableName.valueOf(tableName));
        return exists;
    }

    public static void close() throws IOException {
        if(admin != null){
            admin.close();
        }

        if(connection!=null){
            connection.close();
        }
    }

    public static void main(String[] args) throws IOException {
        System.out.println(isTableExist("Stu"));

        close();

    }
}

创建表

    //    创建表
    public static void createTable(String tableName, String... cfs) throws IOException {

        //1.判断是否存在列族信息
        if (cfs.length <= 0) {
            System.out.println("请设置列族信息！");
            return;
        }

//        2.判断表是否存在
        if (isTableExist(tableName)) {
            System.out.println(tableName + "表已存在！");
            return;
        }

//        3.创建表描述器
        HTableDescriptor hTableDescriptor = new HTableDescriptor(TableName.valueOf(tableName));

//        4.循环添加列族信息
        for (String cf : cfs) {
            //5.创建列族描述器
            HColumnDescriptor hColumnDescriptor = new HColumnDescriptor(cf);

            hTableDescriptor.addFamily(hColumnDescriptor);
        }

//        创建表
        admin.createTable(hTableDescriptor);
    }

创建命名空间

//创建命名空间
    public static void createNameSpace(String ns){
        //1.创建命名空间描述器
        NamespaceDescriptor namespaceDescriptor = NamespaceDescriptor.create(ns).build();
        //2.创建命名空间
        try {
            admin.createNamespace(namespaceDescriptor);
        }catch (NamespaceExistException e){
            System.out.println(ns+"命名空间已存在！");
        }
        catch (IOException e) {
            e.printStackTrace();
        }
    }

删除表

 //删除表
    public static void dropTable(String tableName) throws IOException {
        if(!isTableExist(tableName)){
            System.out.println(tableName+"表不存在");
            return;
        }
        //使表下线
        admin.disableTable(TableName.valueOf(tableName));
        //删除表
        admin.deleteTable(TableName.valueOf(tableName));
    }

DML

向表插入数据

  //    5.向表插入数据
    public static void putData(String tableName, String rowKey, String cf, String cn, String value) throws IOException {
//        1.获取表对象
        Table table = connection.getTable(TableName.valueOf(tableName));
//2.创建put对象，HBase底层所有的存储都是字节
        Put put = new Put(Bytes.toBytes(rowKey));
//3.给Put对象复制
        put.addColumn(Bytes.toBytes(cf),Bytes.toBytes(cn),Bytes.toBytes(value));
//        4.插入数据
        table.put(put);
//        5.关闭表连接
        table.close();

    }

获取数据

 //6.获取数据
    public static void getData(String tableName,String rowKey,String cf,String cn) throws IOException {
        //1.获取表对象
        Table table = connection.getTable(TableName.valueOf(tableName));
        //2.创建Get对象
        Get get = new Get(Bytes.toBytes(rowKey));

//        指定获取的列族
        get.addFamily(Bytes.toBytes(cf));
        //获取列族和列
        get.addColumn(Bytes.toBytes(cf),Bytes.toBytes(cn));
        //设置版本数,(设置多少返回多少个版本，当超过版本只返回HBase的版本)
        get.setMaxVersions(5);


        //3.获取数据
        Result result = table.get(get);
        //4.解析result并打印
        for (Cell cell : result.rawCells()) {
//            5.打印数据
            System.out.println("CF:"+Bytes.toString(cloneFamily(cell))+
             ",CN："+Bytes.toString(CellUtil.cloneQualifier(cell))+
                    ",Value："+Bytes.toString(CellUtil.cloneValue(cell))
            );
        }
//        6.关闭表
        table.close();
    }

扫描表

//    获取数据Scan
    public static void scanTable(String tableName) throws IOException {
//        获取表对象
        Table table = connection.getTable(TableName.valueOf(tableName));
//        构建Scan对象
        Scan scan = new Scan();
//        扫描全表
        ResultScanner resultScanner = table.getScanner(scan);
//        解析resultScanner
        for(Result result:resultScanner){
//            解析result并打印
            for (Cell cell : result.rawCells()) {
                System.out.println("CF:"+Bytes.toString(cloneFamily(cell))+
                        ",CN："+Bytes.toString(CellUtil.cloneQualifier(cell))+
                        ",Value："+Bytes.toString(CellUtil.cloneValue(cell))
                );
            }
        }
//        关闭连接
        table.close();
    }

删除数据

//删除数据
    public static void deleteData(String tableName,String rowKey,String cf,String cn) throws IOException {
//        获取表对象
        Table table = connection.getTable(TableName.valueOf(tableName));
//        构建删除对象
        Delete delete = new Delete(Bytes.toBytes(rowKey));

//        设置删除的列
        delete.addColumns(Bytes.toBytes(cf),Bytes.toBytes(cn));

//        执行删除操作
        table.delete(delete);
//        关闭连接
        table.close();
    }