Java操作HBase

Java操作HBase

导入配置文件

代码

public class Demo
{
    Admin admin = null;
    Connection conn = null;

	//构造代码块
    {
        try
        {
            //创建配置
            Configuration conf = HBaseConfiguration.create();
            //设置zookeeper地址
            conf.set("hbase.zookeeper.quorum", "hadoop");
            conf.set("hbase.zookeeper.property.clientPort", "2181");
            //创建连接
            conn = ConnectionFactory.createConnection(conf);
            //创建admin
            admin = conn.getAdmin();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }


    //判断表是否存在
    @Test
    public void isTableExists() throws IOException
    {
        boolean exists = admin.tableExists(TableName.valueOf("tmpTable"));
        System.out.println(exists);
    }


    //创建表
    @Test
    public void createTable() throws IOException
    {
        //创建表描述信息
        HTableDescriptor hTableDescriptor = new HTableDescriptor(TableName.valueOf("tmpTable"));
        //添加列簇1
        hTableDescriptor.addFamily(new HColumnDescriptor("cf1"));
        //添加列簇2
        hTableDescriptor.addFamily(new HColumnDescriptor("cf2"));
        //创建
        admin.createTable(hTableDescriptor);
    }


    //查看所有表信息
    @Test
    public void listTable() throws IOException
    {
        HTableDescriptor[] hTableDescriptors = admin.listTables();
        for (HTableDescriptor tableDescriptor : hTableDescriptors)
        {
            System.out.println(tableDescriptor.getNameAsString());
        }
    }


    //插入数据
    @Test
    public void putData2Tabel() throws IOException
    {
        //获取table
        Table table = conn.getTable(TableName.valueOf("tmpTable"));
        //创建一个put,添加row key
        Put put = new Put(Bytes.toBytes("1001"));
        //添加 列簇 , 列 , 值
        put.addColumn(Bytes.toBytes("cf1"), Bytes.toBytes("name"), Bytes.toBytes("zhangsan"));
        //插入数据
        table.put(put);
    }


    //查看一条数据
    @Test
    public void getTable() throws IOException
    {
        //获取table
        Table table = conn.getTable(TableName.valueOf("tmpTable"));
        //创建一个get
        Get get = new Get(Bytes.toBytes("1001"));
        //调用api执行get方法
        Result result = table.get(get);
        //遍历
        Cell[] cells = result.rawCells();
        for (Cell cell : cells)
        {
            System.out.println("row_key : " + 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 scanTable() throws IOException
    {
        //获取table
        Table table = conn.getTable(TableName.valueOf("tmpTable"));
        ResultScanner scanner = table.getScanner(new Scan());
        for (Result result : scanner)
        {
            Cell[] cells = result.rawCells();
            for (Cell cell : cells)
            {
                System.out.println("row_key : " + 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
    {
        //禁用表
        admin.disableTable(TableName.valueOf("tmpTable"));
        //删除
        admin.deleteTable(TableName.valueOf("tmpTable"));
    }
}