在java中读取hbase中的表并增加数据或按条件查询数据

最新推荐文章于 2024-06-28 15:58:59 发布

搬运工小刚

最新推荐文章于 2024-06-28 15:58:59 发布

阅读量956

点赞数

分类专栏： Hbase 文章标签： hbase java

本文链接：https://blog.csdn.net/iamboluke/article/details/105496730

版权

Hbase 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

java 读取hbase中的表并增加数据或过滤查看数据

Maven中

导入hbase-client 1.2.0、hbase-server 、 hbase-common

public class ConnTest{
	Configuration conf = HBaseConfigration.create();
	conf.set("hbase.zookeeper.quorum","192.168.56.100:2181");
	Connection conn = ConnectionFactory.createConnection(conf);
	Table users = conn.getTable(TableName.valueof("mydemo:users"));

查看HBase中的表多数数据

Scan scan = new Scan();
	ResultScanner res = users.getScanner(scan);
	for(Result rs : res){
		System.out.println(Bytes.toString(rs.getValue("cf".getBytes(),"fname".getBytes())));
		System.out.println(Bytes.toString(rs.getValue("base".getBytes(),"username".getBytes()))+":"+rs.getValue("details".getBytes(),"like".getBytes()));
	}
	res.close();
	conn.close();

查看HBase中的表一个行键的数据

Get get = new Get("1".getBytes());
        Result result = customer.get(get);
        System.out.println(Bytes.toString(result.getValue("cf".getBytes(),"fname".getBytes())));

插入数据

Put putt = new Put("5".getBytes()); //这里的 "5" 是行键
	putt.addColumn("base".getBytes(),"username".getBytes(),"gugang".getBytes());
	putt.addColumn("base".getBytes(),"age".getBytes(),"22".getBytes());
	putt.addColumn("details".getBytes(),"like".getBytes(),"sleep,eat".getBytes());
	users.put(putt);
	conn.close();

过滤查看数据

SingleColumnValueFilter scvf =
                new SingleColumnValueFilter("cf".getBytes(),
                        "fname".getBytes(),
                       CompareFilter.CompareOp.EQUAL,
                        new RegexStringComparator("J.*"));
       Scan scan = new Scan();
       scan.setFilter(scvf);
        ResultScanner res = customer.getScanner(scan);
        for (Result rs : res) {
            System.out.println(Bytes.toString(rs.getValue("cf".getBytes(), "fname".getBytes()))
                    +":"+rs.getValue("cf".getBytes(),"lname".getBytes()));
        }
        res.close();
        conn.close();
}