Hbase API高级特性-比较过滤器

1.   过滤器在客户端创建，通过RPC传送到服务器端，然后再服务器端执行过滤操作。

2.   行过滤器（RowFilter）

public void rowFilterScan() throws IOException{
Scan scan = new Scan();
//scan.addColumn(Bytes.toBytes("info"),Bytes.toBytes("add"));

System.out.println("小于等于比较@@@@@@@@@");
Filter filter1 = new RowFilter(CompareFilter.CompareOp.EQUAL,
new BinaryComparator(Bytes.toBytes("3103")));
scan.setFilter(filter1);
ResultScanner scanner1 = table.getScanner(scan);
for(Result res:scanner1){
System.out.println(res);
//System.out.println(Bytes.toString(res.getRow())+"   "+
//Bytes.toString(res.value()));
}

scanner1.close();

System.out.println("正则表达式匹配@@@@@@@@@");
Filter filter2 = new RowFilter(CompareFilter.CompareOp.EQUAL,
new RegexStringComparator(".*-.10"));
scan.setFilter(filter2);
ResultScanner scanner2 = table.getScanner(scan);
for(Result res:scanner2)
System.out.println(res);
scanner2.close();

System.out.println("子串匹配@@@@@@@@@@@@");
Filter filter3 = new RowFilter(CompareFilter.CompareOp.EQUAL,
new SubstringComparator("06"));
scan.setFilter(filter3);
ResultScanner scanner3 = table.getScanner(scan);
for(Result res:scanner3)
System.out.println(res);
scanner3.close();
}

3.   列簇过滤器（FamilyFilter）

public void familyFilter() throws IOException{
Filter filter1 = new FamilyFilter(CompareFilter.CompareOp.LESS,
new BinaryComparator(Bytes.toBytes("info")));

Scan scan = new Scan();
scan.setFilter(filter1);
ResultScanner scanner1 = table.getScanner(scan);
for(Result res:scanner1){
System.out.println(res);
}
scanner1.close();

Get get = new Get(Bytes.toBytes("3106"));
get.setFilter(filter1);
Result result1 = table.get(get);
System.out.println("result of get()： " + result1);

Filter filter2 = new FamilyFilter(CompareFilter.CompareOp.EQUAL,
new BinaryComparator(Bytes.toBytes("info")));
Get get2 = new Get(Bytes.toBytes("3103"));
get2.addFamily(Bytes.toBytes("info"));
get2.setFilter(filter2);
Result result2 = table.get(get2);
System.out.println("Result of get():  "+result2);
}

4.列名过滤器（QualifierFilter）

public void qualifierFilter() throws IOException{
Filter filter = new QualifierFilter(CompareFilter.CompareOp.EQUAL,
new BinaryComparator(Bytes.toBytes("add")));
Scan scan = new Scan();
scan.setFilter(filter);
ResultScanner scanner =table.getScanner(scan);
for(Result res:scanner)
System.out.println(res);
scanner.close();

Get get = new Get(Bytes.toBytes("3017"));
get.setFilter(filter);
Result result = table.get(get);
System.out.println("Result of get(): "+ result);
}

5.值过滤器（ValueFilter）

public void valueFilter() throws IOException{
Filter filter = new ValueFilter(CompareFilter.CompareOp.EQUAL,
new BinaryComparator(Bytes.toBytes("cw")));
Scan scan = new Scan();
scan.setFilter(filter);
ResultScanner scanner = table.getScanner(scan);
for(Result res:scanner){
for(KeyValue kv:res.raw())
System.out.println("KV: "+kv +",value: "+ Bytes.toString(kv.getValue()));
}
scanner.close();
}

6.参考列过滤器

该过滤器与扫描操作的批量处理功能不兼容。

public void dependentColumnFilter(boolean drop , CompareFilter.CompareOp operator,
WritableByteArrayComparable comparator) throws IOException{
//drop的true,false决定参考列是被返回还是被丢弃
Filter filter;
if(comparator != null){
filter = new DependentColumnFilter(Bytes.toBytes("info"),
Bytes.toBytes("age"),drop,operator , comparator);
}
else{
filter = new DependentColumnFilter(Bytes.toBytes("info"),
Bytes.toBytes("name"),drop);
}

Scan scan = new Scan();
scan.setFilter(filter);
ResultScanner scanner = table.getScanner(scan);
for(Result res : scanner){
for(KeyValue kv : res.raw()){
System.out.println("KV1： "+kv+",value: "+
Bytes.toString(kv.getValue()));
}
}

Get get = new Get(Bytes.toBytes("3105"));
get.setFilter(filter);
Result result = table.get(get);
for(KeyValue kv:result.raw()){
System.out.println("KV2： "+kv+",value: "+
Bytes.toString(kv.getValue()));
}
}