Java 操作hbase:多条件查询：用 scan.setFilter()

最新推荐文章于 2024-07-07 00:00:00 发布

付月半子

最新推荐文章于 2024-07-07 00:00:00 发布

阅读量4.4k

点赞数

本文链接：https://blog.csdn.net/qq_34169240/article/details/100984083

版权

Java 同时被 3 个专栏收录

54 篇文章 0 订阅

订阅专栏

hbase

4 篇文章 0 订阅

订阅专栏

spark

2 篇文章 0 订阅

订阅专栏

默认正序扫描，若倒序，则 scan.setReversed(true);//倒序扫描

List<Filter> filters = new ArrayList<Filter>();
		Filter filter0 = new SingleColumnValueFilter(Bytes.toBytes("param"), Bytes.toBytes("SBID"), CompareOp.EQUAL,Bytes.toBytes(sbId));
        filters.add(filter0);
        Filter filter1 = new SingleColumnValueFilter(Bytes.toBytes("param"), Bytes.toBytes("paramCode"), CompareOp.EQUAL,Bytes.toBytes(warnParamColumn));
        filters.add(filter1);
        Filter filter2 = new SingleColumnValueFilter(Bytes.toBytes("param"), Bytes.toBytes("dataTime"), CompareOp.GREATER_OR_EQUAL,Bytes.toBytes(beginTime));
        filters.add(filter2);
        Filter filter3 = new SingleColumnValueFilter(Bytes.toBytes("param"), Bytes.toBytes("dataTime"), CompareOp.LESS_OR_EQUAL,Bytes.toBytes(endTime));
        filters.add(filter3);
		
        FilterList filterList1 = new FilterList(filters);
        Scan scan = new Scan();
        scan.setFilter(filterList1);
	    ResultScanner rs = null;
	    Table table = hbase.getConnection().getTable(TableName.valueOf(tableName));
	    try {
	         rs = table.getScanner(scan);
	         for (Result r : rs) {
	             for (Cell cell : r.listCells()) {
	                 
	                  System.out.println("row:" + Bytes.toString(cell.getRowArray(),cell.getRowOffset(),cell.getRowLength()));
	                 System.out.println("family:" + Bytes.toString(cell.getFamilyArray(),cell.getFamilyOffset(),cell.getValueLength()));
	                 System.out.println("qualifier:"  + Bytes.toString(cell.getQualifierArray(),cell.getQualifierOffset(),cell.getQualifierLength()));
	                 System.out.println("value:" + Bytes.toString(cell.getValueArray(),cell.getValueOffset(),cell.getValueLength()));
	                 System.out.println("timestamp:" + cell.getTimestamp());
	                 System.out.println("-------------------------------------------");
 
	                 }
	                 
	             }
	         }
	    } finally {
	         rs.close();
	    }