hbaseApi操作

最新推荐文章于 2024-11-12 23:19:46 发布

热心市民爱抽烟屁

最新推荐文章于 2024-11-12 23:19:46 发布

阅读量207

点赞数

CC 4.0 BY-SA版权

文章标签：大数据 hbase

本文链接：https://blog.youkuaiyun.com/TYM112/article/details/118410019

该博客介绍了如何使用Java API进行HBase操作，包括创建表`testcustomer1`，设置列族`personalInfo`、`recordInfo`和`assetsInfo`，插入数据到指定rowkey，并查询表中数据。示例代码详细展示了配置Zookeeper、HBase连接、表管理及数据读写过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.lhh.hbaseapi;

import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.HBaseConfiguration;
import org.apache.hadoop.hbase.HColumnDescriptor;
import org.apache.hadoop.hbase.HTableDescriptor;
import org.apache.hadoop.hbase.TableName;
import org.apache.hadoop.hbase.client.*;

/**
* @program: lhh
* @description:
* @author: 华仔
* @create: 2021-05-18 15:31
*/
public class HBaseJavaApi {
  public static void main(String[] args) {
      createTbale();
      insertIntoTable();
      getTable();
  }

  //创建表
  public static void createTbale() {
      Configuration conf = HBaseConfiguration.create();
      conf.set("hbase.zookeeper.quorum", "主机ip"); //配置zookeeper的主机
      conf.set("hbase.zookeeper.property.clientPort", "2181"); //配置zookeeper的端口
      conf.set("hbase.master", "主机ip:16000"); //hbase IPC 端口

      Connection connection = null;
      Admin admin = null;
      try {
          //连接HBASE
          connection = ConnectionFactory.createConnection(conf);
          admin = connection.getAdmin();//创建DDL定义
          if (admin.isTableAvailable(TableName.valueOf("testcustomer1"))) {
              //表已存在,删除表
              //禁用表
              admin.disableTable(TableName.valueOf("testcustomer1"));
              //删除表
              admin.deleteTable(TableName.valueOf("testcustomer1"));
              System.out.println("删除成功");
          }
          //创建表
          //表名
          HTableDescriptor customer = new HTableDescriptor(TableName.valueOf("testcustomer1"));
          //指定列族
          customer.addFamily(new HColumnDescriptor("personalInfo"));
          customer.addFamily(new HColumnDescriptor("recordInfo"));
          customer.addFamily(new HColumnDescriptor("assetsInfo"));
          //创建
          admin.createTable(customer);
          System.out.println("创建成功");
      } catch (Exception e) {
          e.printStackTrace();
      } finally {
          try {
              admin.close();
              connection.close();
              System.out.println("关闭资源");
          } catch (Exception e) {
              e.printStackTrace();
          }
      }

  }

  //添加数据
  public static void insertIntoTable() {
      Configuration conf = HBaseConfiguration.create();
      conf.set("hbase.zookeeper.quorum", "192.168.126.135"); //配置zookeeper的主机
      conf.set("hbase.zookeeper.property.clientPort", "2181"); //配置zookeeper的端口
      conf.set("hbase.master", "192.168.126.135:16000"); //hbase IPC 端口

      Connection connection = null;
      Admin admin = null;
      Table table = null;
      try {
          //连接HBASE
          connection = ConnectionFactory.createConnection(conf);
          admin = connection.getAdmin();//创建DML定义
          if (admin.tableExists(TableName.valueOf("testcustomer1"))) { //如果表存在就添加数据
              //指定表名
              table = connection.getTable(TableName.valueOf("testcustomer1"));
              //指定rowkey, 如果rowkey一样就会覆盖,每一次加数据时rowkey需要不一致
              //列族可以一样,列族的类名可以一样,但是前提条件下需要rowkey不一致
              Put put_key = new Put("1001_lhh".getBytes());
              //指定列族并且指定列族的列名,并且添加value
              Put put_column1 = put_key.addColumn("personalInfo".getBytes(), "id".getBytes(), "1001".getBytes());
              Put put_column2 = put_key.addColumn("recordInfo".getBytes(), "id".getBytes(), "1001".getBytes());
              Put put_column3 = put_key.addColumn("assetsInfo".getBytes(), "id".getBytes(), "1001".getBytes());
              //添加
              table.put(put_key);
              System.out.println("添加数据完成");
          }
      } catch (Exception e) {
          e.printStackTrace();
      } finally {
          try {
              table.close();
              admin.close();
              connection.close();
              System.out.println("关闭资源");
          } catch (Exception e) {
              e.printStackTrace();
          }
     }

 }

  //查看数据
  public static void getTable() {
      Configuration conf = HBaseConfiguration.create();
      conf.set("hbase.zookeeper.quorum", "192.168.126.135"); //配置zookeeper的主机
      conf.set("hbase.zookeeper.property.clientPort", "2181"); //配置zookeeper的端口
     conf.set("hbase.master", "192.168.126.135:16000"); //hbase IPC 端口

      Connection connection = null;
      Admin admin = null;
      Table table = null;
      try {
          //连接HBASE
          connection = ConnectionFactory.createConnection(conf);
         admin = connection.getAdmin();//创建DML定义

          if (admin.tableExists(TableName.valueOf("testcustomer1"))) { //如果表存在就查看数据
              table = connection.getTable(TableName.valueOf("testcustomer1"));
              //指定rowkey
              Get get = new Get("1001_lhh".getBytes());
              //指定rowkey
              Result result = table.get(get);
              //获取值
              byte[] value = result.getValue("personalInfo".getBytes(), "id".getBytes());
              System.out.println("获取值-->"+new String(value));
              byte[] value1 = result.getValue("recordInfo".getBytes(), "id".getBytes());
              System.out.println("获取值1-->"+new String(value1));
              byte[] value2 = result.getValue("assetsInfo".getBytes(), "id".getBytes());
              System.out.println("获取值2-->"+new String(value2));
          }
      } catch (Exception e) {
          e.printStackTrace();
      } finally {
          try {
              table.close();
              admin.close();
              connection.close();
              System.out.println("关闭资源");
          } catch (Exception e) {
              e.printStackTrace();
          }
      }
 }
}