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();
}
}
}
}
hbaseApi操作
最新推荐文章于 2024-06-17 21:18:30 发布
该博客介绍了如何使用Java API进行HBase操作,包括创建表`testcustomer1`,设置列族`personalInfo`、`recordInfo`和`assetsInfo`,插入数据到指定rowkey,并查询表中数据。示例代码详细展示了配置Zookeeper、HBase连接、表管理及数据读写过程。
摘要由CSDN通过智能技术生成