使用java操作HBase

前提：

HBase版本为 hbase0.94.18.tar.gz

使用HBase的Java api，对HBase进行操作。

1、连接hbase

1 2 3 4 5 6 7 8

//设置配置信息 public Configuration getConfig() { Configuration conf = HBaseConfiguration.create(); conf.set("hbase.master","192.168.206.21:60000"); conf.set("hbase.zookeeper.quorum","192.168.206.22,192.168.206.23,192.168.206.24"); conf.set("hbase.zookeeper.property.clientport","2181"); return conf; }

2、在hbase中创建表

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

// 创建表 public boolean createTable(Configuration conf, String tableName) { boolean result = false; HBaseAdmin hBaseAdmin = null; try { hBaseAdmin =new HBaseAdmin(conf); if (hBaseAdmin.tableExists(tableName)) { hBaseAdmin.disableTable(tableName); hBaseAdmin.deleteTable(tableName); } HTableDescriptor hTableDescriptor =new HTableDescriptor(tableName); hTableDescriptor.addFamily(new HColumnDescriptor("columnFamily1")); hBaseAdmin.createTable(hTableDescriptor); result = true; }catch (MasterNotRunningException e) { e.printStackTrace(); result = false; }catch (ZooKeeperConnectionException e) { e.printStackTrace(); result = false; }catch (IOException e) { e.printStackTrace(); result = false; }finally { try { hBaseAdmin.close(); }catch (IOException e) { e.printStackTrace(); } } return result; }

3、往HBase插入记录

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

// 插入一条记录 public boolean putRowIntoTable(Configuration conf,String tableName){ boolean result = false; HTable hTable = null; try { hTable =new HTable(conf, tableName); Put put =new Put("rowkey001".getBytes()); put.add("columnFamily1".getBytes(),"column1".getBytes(),"value1".getBytes()); put.add("columnFamily1".getBytes(),"column2".getBytes(),"value2".getBytes()); hTable.put(put); result = true; }catch (IOException e) { e.printStackTrace(); result = false; }finally { try { hTable.close(); }catch (IOException e) { e.printStackTrace(); } } return result; }

4、删除记录

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

// 删除一条记录 public boolean deleteRow(Configuration conf,String hTableName,String rowKey){ boolean result = false; HTable hTable = null; try { hTable =new HTable(conf,hTableName); hTable.delete(new Delete(rowKey.getBytes())); result = true; }catch (IOException e) { e.printStackTrace(); result = false; }finally { try { hTable.close(); }catch (IOException e) { e.printStackTrace(); } } return result; }

5、删除表

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

//删除表 public boolean dropTable(Configuration conf, String tableName){ boolean result = false; HBaseAdmin hBaseAdmin = null; try { hBaseAdmin =new HBaseAdmin(conf); if(hBaseAdmin.tableExists(tableName)){ hBaseAdmin.disableTable(tableName); hBaseAdmin.deleteTable(tableName); }else{ System.err.println(tableName +" is not exist!"); } result = true; }catch (IOException e) { e.printStackTrace(); result = false; }finally { try { hBaseAdmin.close(); }catch (IOException e) { e.printStackTrace(); } } return result; }