使用SingleColumnValueFilter实现Hbase列字段过滤

最新推荐文章于 2024-05-04 05:14:47 发布

hooyang

最新推荐文章于 2024-05-04 05:14:47 发布

阅读量1k

点赞数

分类专栏： hbase

本文链接：https://blog.csdn.net/hooyang/article/details/99539871

版权

hbase 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

   public static void QueryByCondition(String tableName, String v1) {
        try {
            Connection connection = ConnectionFactory.createConnection(conf);
            HTable htable = (HTable) connection.getTable(TableName.valueOf(tableName));
            List<Filter> filters = new ArrayList<Filter>();
            Filter filter1 = new SingleColumnValueFilter(Bytes.toBytes("f"), Bytes.toBytes("appid"), CompareFilter.CompareOp.EQUAL, Bytes.toBytes(v1));
            filters.add(filter1);
            FilterList filterList1 = new FilterList(filters);

            Scan scan = new Scan();
            scan.setStartRow("000000000001242019032600".getBytes());
            scan.setStopRow("999999999991242019032623".getBytes());
            scan.setFilter(filterList1);

            ResultScanner rs = htable.getScanner(scan);
            for (Result r : rs) {
                System.out.println("获得到rowkey:" + new String(r.getRow()));
                for (KeyValue keyValue : r.raw()) {
                    System.out.println("列：" + new String(keyValue.getFamily())
                            + "====值:" + new String(keyValue.getValue()));
                }
            }
            rs.close();

        } catch (Exception e) {
            e.printStackTrace();
        }

    }