Hbase用java基础操作

HbaseCreate--建表

package Hbase;

import java.io.IOException;


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.MasterNotRunningException;
import org.apache.hadoop.hbase.ZooKeeperConnectionException;
import org.apache.hadoop.hbase.client.HBaseAdmin;

public class HbaseCreate {

    public static Configuration configuration;
    static {
        configuration = HBaseConfiguration.create();
        configuration.set("hbase.zookeeper.property.clientPort", "2181");
        configuration.set("hbase.zookeeper.quorum", "192.168.121.132");
        configuration.set("hbase.master", "192.168.121.132:60000");
    }

    public static void main(String[] args) {
         createTable("ecpcibimbqm:instrument");
}
    public static void createTable(String tableName) {
        System.out.println("start create table ......");
        try {
            HBaseAdmin hBaseAdmin = new HBaseAdmin(configuration);
            if (hBaseAdmin.tableExists(tableName)) {
                hBaseAdmin.disableTable(tableName);
                hBaseAdmin.deleteTable(tableName);
                System.out.println(tableName + " is exist,detele....");
            }
            HTableDescriptor tableDescriptor = new HTableDescriptor(tableName);
            tableDescriptor.addFamily(new HColumnDescriptor("d"));
            tableDescriptor.addFamily(new HColumnDescriptor("i"));
            hBaseAdmin.createTable(tableDescriptor);
        } catch (MasterNotRunningException e) {
            e.printStackTrace();
        } catch (ZooKeeperConnectionException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        System.out.println("end create table ......");
    }
}

HbaseInsert--插入

package Hbase;

import java.io.IOException;


import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.HBaseConfiguration;

import org.apache.hadoop.hbase.client.HTable;
import org.apache.hadoop.hbase.client.HTablePool;
import org.apache.hadoop.hbase.client.Put;


public class HbaseInsert {

    public static Configuration configuration;
    static {
        configuration = HBaseConfiguration.create();
        configuration.set("hbase.zookeeper.property.clientPort", "2181");
        configuration.set("hbase.zookeeper.quorum", "192.168.121.132");
        configuration.set("hbase.master", "192.168.121.132:60000");
    }

    public static void main(String[] args) throws IOException {
         insertData("ecpcibimbqm:instrument");
}
     public static void insertData(String tableName) throws IOException {  
        System.out.println("start insert data ......");  
        //HTablePool pool = new HTablePool(configuration, 1000);  
        HTable table = new HTable(configuration, tableName);  
        Put put = new Put("Relationship".getBytes());
        put.add("d".getBytes(), "effectfrom".getBytes(), "2017".getBytes());
        //put.add("d:effectto".getBytes(), null, "2019".getBytes()); 
        try {  
            table.put(put);  
        } catch (IOException e) {  
            e.printStackTrace();  
        }  
        System.out.println("end insert data ......");  
    }  
}

HbaseCI-建表加插入

package Hbase;

import java.io.IOException;

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.client.HBaseAdmin;
import org.apache.hadoop.hbase.client.HTable;
import org.apache.hadoop.hbase.client.Put;
import org.apache.hadoop.hbase.util.Bytes;

public class HbaseCI {
    // 声明静态配置
    public static Configuration configuration;
    static {
        configuration = HBaseConfiguration.create();
        configuration.set("hbase.zookeeper.property.clientPort", "2181");
        configuration.set("hbase.zookeeper.quorum", "192.168.121.132");
        configuration.set("hbase.master", "192.168.121.132:60000");
    }
    /*
     * 创建表
     * 
     * @tableName 表名
     * 
     * @family 列族列表
     */
    public static void creatTable(String tableName, String[] family) throws Exception {
        HBaseAdmin admin = new HBaseAdmin(configuration);
        HTableDescriptor desc = new HTableDescriptor(tableName);
        for (int i = 0; i < family.length; i++) {
            desc.addFamily(new HColumnDescriptor(family[i]));
        }
        if (admin.tableExists(tableName)) {
            System.out.println("table Exists!");
            System.exit(0);
        } else {
            admin.createTable(desc);
            System.out.println("create table Success!");
        }
    }

    /*
     * 为表添加数据（适合知道有多少列族的固定表）
     * 
     * @rowKey rowKey
     * 
     * @tableName 表名
     * 
     * @column 第一个列族列表
     * 
     * @value 第一个列的值的列表
     * 
     * @column2 第二个列族列表
     * 
     * @value2 第二个列的值的列表
     */
    public static void addData(String tableName, String rowKey,String[] column, String[] value)
            throws IOException {
        Put put = new Put(Bytes.toBytes(rowKey));// 设置rowkey
        HTable table = new HTable(configuration, Bytes.toBytes(tableName));// HTabel负责跟记录相关的操作如增删改查等//
                                                                    // 获取表
        HColumnDescriptor[] columnFamilies = table.getTableDescriptor().getColumnFamilies(); // 获取所有的列族
        for (int i = 0; i < columnFamilies.length; i++) {
            String familyName = columnFamilies[i].getNameAsString(); // 获取列族名
            if (familyName.equals("d")) { // article列族put数据
                for (int j = 0; j < column.length; j++) {
                    put.add(Bytes.toBytes(familyName),
                            Bytes.toBytes(column[j]), Bytes.toBytes(value[j]));
                }
            }
        }
        table.put(put);
        System.out.println("add data Success!");
    }
    public static void main(String[] args) throws Exception {

        // 创建表
        String tableName = "ecpcibimbqm:quote";
        String[] family = { "d" };
        creatTable(tableName, family);

        // 为表添加数据

        String[] column = { "permid", "subject"};
        String[] value = {
                "Head First HBase",
                "HBase is the Hadoop database. Use it when you need random, realtime read/write access to your Big Data."
                };
        String[] column1 = { "uuid", "objectject"};
        String[] value1 = {
                "212312312312312",
                "aaaaaaaaaaaaa"
                };
        addData("ecpcibimbqm:quote", "Relationship", column, value);
        addData("ecpcibimbqm:quote", "Adminstatus", column1, value1);

    }
}

HbaseScan--查看整个表

package Hbase;

import java.io.IOException;


import org.apache.hadoop.conf.Configuration;
import org.apache.hadoop.hbase.HBaseConfiguration;

import org.apache.hadoop.hbase.KeyValue;

import org.apache.hadoop.hbase.client.Get;

import org.apache.hadoop.hbase.client.HTable;

import org.apache.hadoop.hbase.client.Result;

import org.apache.hadoop.hbase.util.Bytes;

public class HbaseScan {
    public static Configuration configuration;
    static {
        configuration = HBaseConfiguration.create();
        configuration.set("hbase.zookeeper.property.clientPort", "2181");
        configuration.set("hbase.zookeeper.quorum", "192.168.121.132");
        configuration.set("hbase.master", "192.168.121.132:60000");
    }
 public static void selectByRowKey(String tablename,String rowKey) throws IOException{
        HTable table=new HTable(configuration,tablename);
        Get g = new Get(Bytes.toBytes(rowKey));
        Result r=table.get(g);
        for(KeyValue kv:r.raw()){
            System.out.println("family: "+ Bytes.toString(kv.getFamily()));
            System.out.println("column:"+ Bytes.toString(kv.getQualifier()));
            System.out.println("value:"+ Bytes.toString(kv.getValue()));
        }
    }

public static void main(String[] args) throws Exception {

        selectByRowKey("ecpcibimbqm:quote","Relationship");

}
}

HbaseZH--hbase综合使用常用API

package Hbase;

import java.io.IOException;  
import java.util.Iterator;  
import java.util.List;  
  
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.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 HbaseZH {  
    // 声明静态配置  
    public static Configuration conf;
    static {
        conf = HBaseConfiguration.create();
        conf.set("hbase.zookeeper.property.clientPort", "2181");
        conf.set("hbase.zookeeper.quorum", "192.168.121.132");
        conf.set("hbase.master", "192.168.121.132:60000");
    }
    /* 
     * 创建表 
     * @tableName 表名 
     * @family 列族列表 
     */  
    public static void creatTable(String tableName, String[] family) throws Exception {  
        HBaseAdmin admin = new HBaseAdmin(conf);  
        HTableDescriptor desc = new HTableDescriptor(tableName);  
        for (int i = 0; i < family.length; i++) {  
            desc.addFamily(new HColumnDescriptor(family[i]));  
        }  
        if (admin.tableExists(tableName)) {  
            System.out.println("table Exists!");  
            System.exit(0);  
        } else {  
            admin.createTable(desc);  
            System.out.println("create table Success!");  
        }  
    }  
    /* 
     * 为表添加数据（适合知道有多少列族的固定表） 
     * @rowKey rowKey 
     * @tableName 表名 
     * @column1 第一个列族列表 
     * @value1 第一个列的值的列表 
     * @column2 第二个列族列表 
     * @value2 第二个列的值的列表 
     */  
    public static void addData(String tableName, String rowKey,String[] column1, String[] value1) throws IOException {  
        Put put = new Put(Bytes.toBytes(rowKey));// 设置rowkey  
        HTable table = new HTable(conf, tableName);// 获取表  
        HColumnDescriptor[] columnFamilies = table.getTableDescriptor().getColumnFamilies();  // 获取所有的列族  
        for (int i = 0; i < columnFamilies.length; i++) {  
            String familyName = columnFamilies[i].getNameAsString(); // 获取列族名  
            if (familyName.equals("d")) { // article列族put数据  
                for (int j = 0; j < column1.length; j++) {  
                    put.add(Bytes.toBytes(familyName),Bytes.toBytes(column1[j]), Bytes.toBytes(value1[j]));  
                }  
            }  
        }  
        table.put(put);  
        System.out.println("add data Success!");  
    }  
    /* 
     * 根据rwokey查询 
     * @rowKey rowKey 
     * @tableName 表名 
     */  
    public static Result getResult(String tableName, String rowKey) throws IOException {  
        Get get = new Get(Bytes.toBytes(rowKey));  
        HTable table = new HTable(conf, tableName);// 获取表  
        Result result = table.get(get);  
        for (KeyValue kv : result.list()) {  
            System.out.println("family:" + Bytes.toString(kv.getFamily()));  
            System.out.println("qualifier:" + Bytes.toString(kv.getQualifier()));  
            System.out.println("value:" + Bytes.toString(kv.getValue()));  
            System.out.println("Timestamp:" + kv.getTimestamp());  
            System.out.println("-------------------------------------------");  
        }  
        return result;  
    }  
  
    /* 
     * 遍历查询hbase表 
     * @tableName 表名 
     */  
    public static void getResultScann(String tableName) throws IOException {  
        Scan scan = new Scan();  
        ResultScanner rs = null;  
        HTable table = new HTable(conf, tableName);  
        try {  
            rs = table.getScanner(scan);  
            for (Result r : rs) {  
                for (KeyValue kv : r.list()) {  
                    System.out.println("family:" + Bytes.toString(kv.getFamily()));  
                    System.out.println("qualifier:" + Bytes.toString(kv.getQualifier()));  
                    System.out.println("value:" + Bytes.toString(kv.getValue()));  
                    System.out.println("timestamp:" + kv.getTimestamp());  
                    System.out.println("-------------------------------------------");  
                }  
            }  
        } finally {  
            rs.close();  
        }  
    }  
  
    /* 
     * 查询表中的某一列 
     * @tableName 表名 
     * @rowKey rowKey 
     */  
    public static void getResultByColumn(String tableName, String rowKey,String familyName, String columnName) throws IOException {  
        HTable table = new HTable(conf, tableName);  
        Get get = new Get(Bytes.toBytes(rowKey));  
        get.addColumn(Bytes.toBytes(familyName), Bytes.toBytes(columnName)); // 获取指定列族和列修饰符对应的列  
        Result result = table.get(get);  
        for (KeyValue kv : result.list()) {  
            System.out.println("family:" + Bytes.toString(kv.getFamily()));  
            System.out.println("qualifier:" + Bytes.toString(kv.getQualifier()));  
            System.out.println("value:" + Bytes.toString(kv.getValue()));  
            System.out.println("Timestamp:" + kv.getTimestamp());  
            System.out.println("-------------------------------------------");  
        }  
    }  
    /* 
     * 更新表中的某一列 
     * @tableName 表名 
     * @rowKey rowKey 
     * @familyName 列族名 
     * @columnName 列名 
     * @value 更新后的值 
     */  
    public static void updateTable(String tableName, String rowKey,String familyName, String columnName, String value)  
            throws IOException {  
        HTable table = new HTable(conf, tableName);  
        Put put = new Put(Bytes.toBytes(rowKey));  
        put.add(Bytes.toBytes(familyName), Bytes.toBytes(columnName),Bytes.toBytes(value));  
        table.put(put);  
        System.out.println("update table Success!");  
    }  
    /* 
     * 查询某列数据的多个版本 
     * @tableName 表名 
     * @rowKey rowKey 
     * @familyName 列族名 
     * @columnName 列名 
     */  
    public static void getResultByVersion(String tableName, String rowKey,String familyName, String columnName) throws IOException {  
        HTable table = new HTable(conf, tableName);  
        Get get = new Get(Bytes.toBytes(rowKey));  
        get.addColumn(Bytes.toBytes(familyName), Bytes.toBytes(columnName));  
        get.setMaxVersions(5);  
        Result result = table.get(get);  
        for (KeyValue kv : result.list()) {  
            System.out.println("family:" + Bytes.toString(kv.getFamily()));  
            System.out.println("qualifier:" + Bytes.toString(kv.getQualifier()));  
            System.out.println("value:" + Bytes.toString(kv.getValue()));  
            System.out.println("Timestamp:" + kv.getTimestamp());  
            System.out.println("-------------------------------------------");  
        }  
        List<?> results = table.get(get).list(); Iterator<?> it = results.iterator(); while (it.hasNext()) {  
        System.out.println(it.next().toString()); }  
    }  
    /* 
     * 删除指定的列 
     * @tableName 表名 
     * @rowKey rowKey 
     * @familyName 列族名 
     * @columnName 列名 
     */  
    public static void deleteColumn(String tableName, String rowKey,String falilyName, String columnName) throws IOException {  
        HTable table = new HTable(conf, tableName);  
        Delete deleteColumn = new Delete(Bytes.toBytes(rowKey));  
        deleteColumn.deleteColumns(Bytes.toBytes(falilyName),Bytes.toBytes(columnName));  
        table.delete(deleteColumn);  
        System.out.println(falilyName + ":" + columnName + "is deleted!");  
    }   
    /* 
     * 删除指定的列 
     * @tableName 表名 
     * @rowKey rowKey 
     */  
    public static void deleteAllColumn(String tableName, String rowKey) throws IOException {  
        HTable table = new HTable(conf, tableName);  
        Delete deleteAll = new Delete(Bytes.toBytes(rowKey));  
        table.delete(deleteAll);  
        System.out.println("all columns are deleted!");  
    }    
    /* 
     * 删除表 
     * @tableName 表名 
     */  
    public static void deleteTable(String tableName) throws IOException {  
        HBaseAdmin admin = new HBaseAdmin(conf);  
        admin.disableTable(tableName);  
        admin.deleteTable(tableName);  
        System.out.println(tableName + "is deleted!");  
    }    
    public static void main(String[] args) throws Exception {  
        // 创建表  
       String tableName = "ecpcibimbqm:quote"; String[] family = { "d","dd" };  
       creatTable(tableName,family);   
        // 为表添加数据  
       String[] column1 = { "permid", "object", "subject" }; 
       String[] value1 = {"Head First HBase",  
        "HBase is the Hadoop database. Use it when you need random, realtime read/write access to your Big Data.",  
        "Hadoop,HBase,NoSQL" }; 
       String[] column2 = { "time", "data" };  
       String[] value2 = { "nicholas", "lee" }; 
       addData(tableName, "Relationship", column1, value1);  
       addData(tableName, "Admainstatus", column2, value2); 
        // 删除一列  
       deleteColumn(tableName, "Relationship", "d", "permid");    
        // 删除所有列  
       deleteAllColumn(tableName, "Admainstatus");            
        //删除表  
        deleteTable(tableName);    
        // 查询  
        getResult(tableName, "Relationship");    
        // 查询某一列的值  
        getResultByColumn(tableName, "Relationship", "d", "object");  
        updateTable(tableName, "Relationship", "d", "object","update");    
        // 遍历查询  
        getResultScann(tableName);    
        // 查询某列的多版本  
        getResultByVersion(tableName, "Relationship", "d", "subject");  
    }  
}  

hbase执行过程不执行MapReduce,直接java编译就可以

/usr/local/jdk1.7.0_25/bin/javac Hbase.java

/usr/local/jdk1.7.0_25/bin/java Hbase