HBase学习-表的增删改插

最新推荐文章于 2024-10-18 14:25:33 发布

u014372225

最新推荐文章于 2024-10-18 14:25:33 发布

阅读量342

点赞数

分类专栏： hBase 文章标签： hbase

本文链接：https://blog.csdn.net/u014372225/article/details/68947866

版权

hBase 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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.*;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by Administrator on 2016/12/12 0012.
 */

public class HBase {

    private static final String TABLE_NAME = "stu_table";
    private static final String FAMILY_NAME = "f1";
    private static final String COLUMN_NAME = "name";
    private static final String COLUMN_AGE = "age";
    private static final String ROW_KEY1 = "r1";
    private static final String ROW_KEY2 = "r2";

    public static void main(String[] args) throws Exception {
        Configuration conf = HBaseConfiguration.create();
        conf.set("hbase.rootdir", "hdfs://master:9000/hbase");
        conf.set("hbase.zookeeper.quorum", "master:2181");

        //create
        HBaseAdmin hBaseAdmin = new HBaseAdmin(conf);
        if (!hBaseAdmin.tableExists(TABLE_NAME)) {

            HTableDescriptor hTableDescriptor = new HTableDescriptor(TABLE_NAME);
            hTableDescriptor.addFamily(new HColumnDescriptor(FAMILY_NAME));
            hBaseAdmin.createTable(hTableDescriptor);
            System.out.println("table create success !");
        } else {
            System.out.println("table exits");
        }
        //insert
        HTable hTable = new HTable(conf, TABLE_NAME);
        List<Put> putList = new ArrayList<Put>();
        Put put1 = new Put(ROW_KEY1.getBytes());
        put1.add(FAMILY_NAME.getBytes(), COLUMN_NAME.getBytes(), "ylz".getBytes());
        put1.add(FAMILY_NAME.getBytes(), COLUMN_AGE.getBytes(), "24".getBytes());
        putList.add(put1);

        Put put2 = new Put(ROW_KEY2.getBytes());
        put2.add(FAMILY_NAME.getBytes(), COLUMN_NAME.getBytes(), "pf".getBytes());
        put2.add(FAMILY_NAME.getBytes(), COLUMN_AGE.getBytes(), "25".getBytes());
        putList.add(put2);
        hTable.put(putList);

        //scan  一条
        Get get = new Get(ROW_KEY1.getBytes());
        Result result = hTable.get(get);
        String name1 = new String(result.getValue(FAMILY_NAME.getBytes(), COLUMN_NAME.getBytes()));
        String age1 = new String(result.getValue(FAMILY_NAME.getBytes(), COLUMN_AGE.getBytes()));
        System.out.println("name:" + name1 + "\t age1:" + age1);

        //scan 多条
        Scan scan = new Scan();

        //限制起始行和结束行
//        scan.setStartRow(ROW_KEY1.getBytes());
//        scan.setStopRow(ROW_KEY2.getBytes());

        ResultScanner scanner = hTable.getScanner(scan);
        //迭代
        for (Result rs : scanner) {
            String rowKey = new String(result.getRow());
            String name = new String(result.getValue(FAMILY_NAME.getBytes(), COLUMN_NAME.getBytes()));
            String age = new String(result.getValue(FAMILY_NAME.getBytes(), COLUMN_AGE.getBytes()));
            System.out.println(rowKey + "\t" + "name:" + name + "\t age:" + age);
        }

        //delete 一行
        Delete delete = new Delete(ROW_KEY1.getBytes());
        hTable.delete(delete);


        //对表的删除
        hBaseAdmin.disableTable(TABLE_NAME);
        hBaseAdmin.deleteTable(TABLE_NAME);
    }
}