前提:
我们的HADOOP和HBase实在远程服务器上搭建的,各个子节点是不能被远程访问,只有一个外网IP。
所以, 只能将Java程序导出jar包在服务器主节点运行。
Eclipse:
将HBase的lib所有jar包导入该工程下并新建lib文件夹,最后全部Bulid Path-->Add To Build Path
实例代码:
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.KeyValue;
import org.apache.hadoop.hbase.client.*;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
public class HBaseDeom {
private HBaseAdmin admin = null;
// 定义配置对象HBaseConfiguration
private HBaseConfiguration cfg = null;
public HBaseDeom() throws Exception {
Configuration HBASE_CONFIG = new Configuration();
HBASE_CONFIG.set("hbase.zookeeper.quorum", "XXX.XX.XX.XX");//服务器IP
HBASE_CONFIG.set("hbase.zookeeper.property.clientPort", "2181");
cfg = new HBaseConfiguration(HBASE_CONFIG);
admin = new HBaseAdmin(cfg);
}
// 创建一张表,指定表名,列族
public void createTable(String tableName, String columnFarily)
throws Exception {
if (admin.tableExists(tableName)) {
System.out.println(tableName + "存在!");
System.exit(0);
} else {
HTableDescriptor tableDesc = new HTableDescriptor(tableName);
tableDesc.addFamily(new HColumnDescriptor(columnFarily));
admin.createTable(tableDesc);
System.out.println("创建表成功!");
}
}
// Hbase获取所有的表信息
public List getAllTables() {
List<String> tables = null;
if (admin != null) {
try {
HTableDescriptor[] allTable = admin.listTables();
if (allTable.length > 0)
tables = new ArrayList<String>();
for (HTableDescriptor hTableDescriptor : allTable) {
tables.add(hTableDescriptor.getNameAsString());
System.out.println(hTableDescriptor.getNameAsString());
}
} catch (IOException e) {
e.printStackTrace();
}
}
return tables;
}
// Hbase中往某个表中添加一条记录
public boolean addOneRecord(String table, String key, String family,
String col, byte[] dataIn) {
HTablePool tp = new HTablePool(cfg, 1000);
HTable tb = (HTable) tp.getTable(table);
Put put = new Put(key.getBytes());
put.add(family.getBytes(), col.getBytes(), dataIn);
try {
tb.put(put);
System.out.println("插入数据条" + key + "成功!!!");
return true;
} catch (IOException e) {
System.out.println("插入数据条" + key + "失败!!!");
return false;
}
}
// Hbase表中记录信息的查询
public void getValueFromKey(String table, String key) {
HTablePool tp = new HTablePool(cfg, 1000);
HTable tb = (HTable) tp.getTable(table);
Get get = new Get(key.getBytes());
try {
Result rs = tb.get(get);
if (rs.raw().length == 0) {
System.out.println("不存在关键字为" + key + "的行!!");
} else {
for (KeyValue kv : rs.raw()) {
System.out.println(new String(kv.getKey()) + " "
+ new String(kv.getValue()));
}
}
} catch (IOException e) {
e.printStackTrace();
}
}
// 显示所有数据,通过HTable Scan类获取已有表的信息
public void getAllData(String tableName) throws Exception {
HTable table = new HTable(cfg, tableName);
Scan scan = new Scan();
ResultScanner rs = table.getScanner(scan);
for (Result r : rs) {
for (KeyValue kv : r.raw()) {
System.out.println(new String(kv.getKey())
+ new String(kv.getValue()));
}
}
}
// Hbase表中记录信息的删除
public boolean deleteRecord(String table, String key) {
HTablePool tp = new HTablePool(cfg, 1000);
HTable tb = (HTable) tp.getTable(table);
Delete de = new Delete(key.getBytes());
try {
tb.delete(de);
return true;
} catch (IOException e) {
System.out.println("删除记录" + key + "异常!!!");
return false;
}
}
// Hbase中表的删除
public boolean deleteTable(String table) {
try {
if (admin.tableExists(table)) {
admin.disableTable(table);
admin.deleteTable(table);
System.out.println("删除表" + table + "!!!");
}
return true;
} catch (IOException e) {
System.out.println("删除表" + table + "异常!!!");
return false;
}
}
// 测试函数
public static void main(String[] args) {
try {
HBaseDeom hbase = new HBaseDeom();
hbase.createTable("student", "fam1");
// hbase.getAllTables();
// hbase.addOneRecord("student","id1","fam1","name","Jack".getBytes());
// hbase.addOneRecord("student","id1","fam1","address","HZ".getBytes());
// hbase.getValueFromKey("student","id1");
// hbase.getAllData("student");
//hbase.deleteRecord("student", "id1");
//hbase.deleteTable("student");
} catch (Exception e) {
e.printStackTrace();
}
}
}
导出可运行的jar包:
右边第一个框:从下拉框选择改jar的入口文件,即main方法所在的类
第二个框:设置导出jar包的路径和包名
下方Library handling:设置第三方jar包的处理方法:
Extract required libraries into generated JAR:把所有的import JAR都拆开来,包含在JAR的各个目录中。
Package required libraries into generated JAR:把所有的import JAR都包在JAR的根目录下。
Copy required libraries into a sub-folder next to the generated JAR:把所有import JAR放在JAR外面独立的一个文件夹
导入服务器主节点:
进入jar包所在目录:java -jar xxxxx.jar
在服务器运行结果:
用web浏览器查看HBase:
http://IP:16010
数据表存入成功。