本文的内容是在集群中创建java项目调用api来操作hbase,主要涉及对hbase的创建表格,删除表格,插入数据,删除数据,查询一条数据,查询所有数据等操作。具体流程如下:1.创建项目2.获取jar包到项目的lib目录下(这边试用的事hbase 0.98 lib目录下的所有jar包)3.编写java程序4.编写ant脚本
?
?
- package com.wan.hbase;
- import java.io.IOException;
- import org.apache.Hadoop.conf.Configuration;
- import org.apache.hadoop.hbase.Cell;
- import org.apache.hadoop.hbase.CellUtil;
- import org.apache.hadoop.hbase.HBaseConfiguration;
- import org.apache.hadoop.hbase.HColumnDescriptor;
- import org.apache.hadoop.hbase.HTableDescriptor;
- import org.apache.hadoop.hbase.MasterNotRunningException;
- import org.apache.hadoop.hbase.TableName;
- import org.apache.hadoop.hbase.ZooKeeperConnectionException;
- import org.apache.hadoop.hbase.client.Delete;
- import org.apache.hadoop.hbase.client.Get;
- import org.apache.hadoop.hbase.client.HBaseAdmin;
- import org.apache.hadoop.hbase.client.HTable;
- import org.apache.hadoop.hbase.client.Put;
- import org.apache.hadoop.hbase.client.Result;
- import org.apache.hadoop.hbase.client.ResultScanner;
- import org.apache.hadoop.hbase.client.Scan;
- import org.apache.hadoop.hbase.util.Bytes;
-
- public class SimpleHBase {
- public static void main(String[] args) {
- ??Configuration configuration=HBaseConfiguration.create();
- ??String tableName="student";
- ??createTable(configuration, tableName);
- //??addData(configuration, tableName);
- //??getData(configuration, tableName);
- //??getAllData(configuration, tableName);
- //??deleteDate(configuration, tableName);
- //??dropTable(configuration, tableName);
- ??
- }
-
-
- public static void createTable(Configuration configuration,String tableName){
- ??HBaseAdmin admin;
- ??try {
- ???admin = new HBaseAdmin(configuration);
- ???if(admin.tableExists(tableName)){
- ????admin.disableTable(tableName);
- ????admin.deleteTable(tableName);
- ????System.out.println(tableName+"is exist ,delete ......");
- ???}
- ???
- ???
- ???HTableDescriptor tableDescriptor=new HTableDescriptor(TableName.valueOf(tableName));
- ???tableDescriptor.addFamily(new HColumnDescriptor("info"));
- ???tableDescriptor.addFamily(new HColumnDescriptor("address"));
- ???admin.createTable(tableDescriptor);
- ???System.out.println("end create table");
- ??} catch (MasterNotRunningException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (ZooKeeperConnectionException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (IOException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??}
- ??
- }
-
-
- public static void dropTable(Configuration configuration,String tableName){
- ??HBaseAdmin admin;
- ??try {
- ???admin = new HBaseAdmin(configuration);
- ???if(admin.tableExists(tableName)){
- ????admin.disableTable(tableName);
- ????admin.deleteTable(tableName);
- ????System.out.println(tableName+"delete success!");
- ???}else{
- ????System.out.println(tableName+"Table does not exist!");
- ???}
- ??} catch (MasterNotRunningException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (ZooKeeperConnectionException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (IOException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??}
- }
-
-
- public static void addData(Configuration configuration,String tableName){
- ??HBaseAdmin admin;
- ??try {
- ???admin = new HBaseAdmin(configuration);
- ???if(admin.tableExists(tableName)){
- ????HTable table=new HTable(configuration, tableName);
- ????Put put=new Put(Bytes.toBytes("zhangsan"));
- ????put.add(Bytes.toBytes("info"), Bytes.toBytes("age"), Bytes.toBytes("28"));
- ????table.put(put);
- ????System.out.println("add success!");
- ???}else{
- ????System.out.println(tableName+"Table does not exist!");
- ???}
- ??} catch (MasterNotRunningException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (ZooKeeperConnectionException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (IOException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??}
- }
-
-
- public static void deleteDate(Configuration configuration,String tableName){
- ??HBaseAdmin admin;
- ??try {
- ???admin=new HBaseAdmin(configuration);
- ???if(admin.tableExists(tableName)){
- ????HTable table=new HTable(configuration, tableName);
- ????Delete delete=new Delete(Bytes.toBytes("zhangsan"));
- ????table.delete(delete);
- ????System.out.println("delete success!");
- ???}else{
- ????System.out.println("Table does not exist!");
- ???}
- ??} catch (MasterNotRunningException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (ZooKeeperConnectionException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??} catch (IOException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??}
- }
-
-
- public static void getData(Configuration configuration,String tableName){
- ??HTable table;
- ??try {
- ???table = new HTable(configuration, tableName);
- ???Get get=new Get(Bytes.toBytes("zhangsan"));
- ???Result result=table.get(get);
-
- ???for(Cell cell:result.rawCells()){???
- ????System.out.println("RowName:"+new String(CellUtil.cloneRow(cell))+" ");
- ????System.out.println("Timetamp:"+cell.getTimestamp()+" ");
- ????System.out.println("column Family:"+new String(CellUtil.cloneFamily(cell))+" ");
- ????System.out.println("row Name:"+new String(CellUtil.cloneQualifier(cell))+" ");
- ????System.out.println("value:"+new String(CellUtil.cloneValue(cell))+" ");
- ???}
- ??} catch (IOException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??}
- }
-
-
- public static void getAllData(Configuration configuration,String tableName){
- ??HTable table;
- ??try {
- ???table=new HTable(configuration, tableName);
- ???Scan scan=new Scan();
- ???ResultScanner results=table.getScanner(scan);
- ???for(Result result:results){
- ????for(Cell cell:result.rawCells()){???
- ?????System.out.println("RowName:"+new String(CellUtil.cloneRow(cell))+" ");
- ?????System.out.println("Timetamp:"+cell.getTimestamp()+" ");
- ?????System.out.println("column Family:"+new String(CellUtil.cloneFamily(cell))+" ");
- ?????System.out.println("row Name:"+new String(CellUtil.cloneQualifier(cell))+" ");
- ?????System.out.println("value:"+new String(CellUtil.cloneValue(cell))+" ");
- ????}
- ???}
- ??} catch (IOException e) {
- ???// TODO Auto-generated catch block
- ???e.printStackTrace();
- ??}
- ????
- }
- }
?
?
?
?
?
http://blog.sina.com.cn/s/blog_68674da70102vaaw.html