HBase的java编程实例-写入词频统计

//下面代码需要新建一个文本文件作为读取内容import java.io.BufferedReader;import java.io.FileReader;import java.util.List;import java.util.ArrayList;import org.apache.hadoop.conf.Configuration;import org.apache.hadoop.hbase.HBaseConfiguration;import org.apache.hadoop.hbase.client.Delete;import org.apache.hadoop.hbase.client.HBaseAdmin;import org.apache.hadoop.hbase.client.Put;import org.apache.hadoop.hbase.client.Get;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.HTableDescriptor;import org.apache.hadoop.hbase.HColumnDescriptor;import org.apache.hadoop.hbase.client.HTable;import org.apache.hadoop.hbase.util.Bytes;import org.apache.hadoop.hbase.KeyValue;/* * @author michael * 2014.4.22 * * */public class HBaseSample {    static Configuration conf=null;    static{        conf=HBaseConfiguration.create();// this is used to configure the hbase        conf.set("hbase.zookeeper.quorum", "localhost");    }    public static void main(String[] args) {        // TODO Auto-generated method stub        HBaseSample tableNew=new HBaseSample();        try {            HBaseAdmin admin=new HBaseAdmin(conf);            if(admin.tableExists("shakespeare"))   //if the table has existed,delete it            {                admin.disableTable("shakespeare");                admin.deleteTable("shakespeare");            }            tableNew.createTable("shakespeare", new String[]{"word","count"}); //create the table            BufferedReader reader=new BufferedReader(new                    FileReader("wordCountPart.txt"));            String str,rowkey,word,value;            int rowNum=0;            while((str=reader.readLine())!=null)   //循环从文本中读入数据；文本中的每一行是：word count;例如：  a 111;            {                rowNum++;                rowkey=String.valueOf(rowNum);                word=str.split("\t")[0]; //以tbale键分开                value=str.split("\t")[1];                tableNew.insertRow("shakespeare",rowkey,"word","the only word",word);                tableNew.insertRow("shakespeare",rowkey,"count",word+"'s value",value);            }            reader.close();            System.out.println("下面输出整张表");            tableNew.showAll("shakespeare");                    }        catch (Exception e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }    /*****     * create a table,and assign the column     * */    public void createTable(String tableName,String columns[])throws Exception{        HBaseAdmin admin=new HBaseAdmin(conf); //客户端管理工具类        if(admin.tableExists(tableName))            System.out.println("The table is already exist");        else        {            HTableDescriptor table=new HTableDescriptor(tableName);            for(String c:columns)            {                HColumnDescriptor col=new HColumnDescriptor(c);                table.addFamily(col);            }            admin.createTable(table);            admin.close();            System.out.println("The table has been created successfully");        }    }    /**     * delete the table     * */    public void deleteTable(String tableName)throws Exception    {        HBaseAdmin hAdmin=new HBaseAdmin(conf);        if(hAdmin.tableExists(tableName))        {            hAdmin.disableTable(tableName);            hAdmin.deleteTable(tableName);                    }        System.out.println("the table has been deleted successfully!");    }    /**     * add the data     * */    public static Put insertRowByPut(String row,String columnFamily,            String column, String value)    {        Put put=new Put(Bytes.toBytes(row));        put.add(Bytes.toBytes(columnFamily),Bytes.toBytes(column),                Bytes.toBytes(value));        return put;                    }    public void insertRow(String tableName,String row,String columnFamily,            String column, String value)throws Exception{        HTable table=new HTable(conf,tableName);        Put put=new Put(Bytes.toBytes(row));        put.add(Bytes.toBytes(columnFamily),Bytes.toBytes(column),                Bytes.toBytes(value));        table.put(put);        table.close();        System.out.println("The data has been inserted successfully!");    }    /**     * 删除多条数据     * */    public void deleteByRow(String tableName,String rowkey[])throws Exception    {        HTable h=new HTable(conf,tableName);        List<Delete>list=new ArrayList<Delete>();        //Get g=new Get(Bytes.toBytes(rowkey));        for(String k:rowkey)        {            Delete d=new Delete(Bytes.toBytes(k));            list.add(d);        }        h.delete(list);        h.close();    }    /**     * 得到一个数据     * */    public void getOneDataByRowKey(String tableName,String rowkey) throws Exception    {        HTable h=new HTable(conf,tableName);        Get g=new Get(Bytes.toBytes(rowkey));        Result r=h.get(g);        for(KeyValue k:r.raw()){            System.out.println("行是:"+Bytes.toStringBinary(k.getRow()));            System.out.println("时间戳是:"+k.getTimestamp());            System.out.println("列族是:"+Bytes.toStringBinary(k.getFamily()));            System.out.println("列是:"+Bytes.toStringBinary(k.getQualifier()));            String ss=Bytes.toString(k.getValue());            System.out.println("值是"+ss);        }        h.close();    }    /**     * 扫描所有的数据     * */    public void showAll(String tableName) throws Exception{        HTable h=new HTable(conf,tableName);        Scan scan=new Scan();        ResultScanner scanner=h.getScanner(scan);        for(Result r:scanner)        {                        System.out.println("==============================");            for(KeyValue k:r.raw())            {                System.out.println("the rowkey:"+Bytes.toStringBinary(k.getRow()));                System.out.println("the TimeStap:"+k.getTimestamp());                System.out.println("the ColumnKey:"+Bytes.toStringBinary(k.getFamily()));                System.out.println("the Column:"+Bytes.toStringBinary(k.getQualifier()));                String ss=Bytes.toString(k.getValue());                System.out.println("the value:"+ss);            }        }        h.close();    }    }