hbase行键过滤器RowFilter

RowFilter是用来对rowkey进行过滤的,比较符如下:

Operator

Description

LESS

小于

LESS_OR_EQUAL

小于等于

EQUAL

等于

NOT_EQUAL

不等于

GREATER_OR_EQUAL

大于等于

GREATER

大于

NO_OP

排除所有

Comparator

Description

BinaryComparator

使用Bytes.compareTo()比较

BinaryPrefixComparator

和BinaryComparator差不多，从前面开始比较

NullComparator

Does not compare against an actual value but whether a given one is null, or not null.

BitComparator

Performs a bitwise comparison, providing a BitwiseOp class with AND, OR, and XOR operators.

RegexStringComparator

正则表达式

SubstringComparator

把数据当成字符串，用contains()来判断

下面是相关比较符的例子

点击(此处)折叠或打开

1. package com.hxl;
   
2. 
   
3. import java.io.IOException;
   
4. import org.apache.hadoop.conf.Configuration;
   
5. import org.apache.hadoop.hbase.Cell;
   
6. import org.apache.hadoop.hbase.CellUtil;
   
7. import org.apache.hadoop.hbase.KeyValue;
   
8. import org.apache.hadoop.hbase.client.HTable;
   
9. import org.apache.hadoop.hbase.client.Result;
   
10. import org.apache.hadoop.hbase.client.ResultScanner;
    
11. import org.apache.hadoop.hbase.client.Scan;
    
12. import org.apache.hadoop.hbase.filter.BinaryComparator;
    
13. import org.apache.hadoop.hbase.filter.CompareFilter;
    
14. import org.apache.hadoop.hbase.filter.Filter;
    
15. import org.apache.hadoop.hbase.filter.RowFilter;
    
16. import org.apache.hadoop.hbase.util.Bytes;
    
17. 
    
18. import com.hxl.ConnectDB;
    
19. 
    
20. public class RowFilterTest {
    
21. 
    
22.     publicvoid rowfilter(String tablename,String rowkeyvalue){
    
23.         Configurationconfiguration = null;
    
24.         configuration= new ConnectDB().getConf();
    
25. 
    
26.         try{
    
27.             HTable table= new HTable(configuration, tablename);
    
28. 
    
29.             Filter filter1= new RowFilter(CompareFilter.CompareOp.EQUAL,
    
30.                     new BinaryComparator(Bytes.toBytes(rowkeyvalue)));
    
31.             // EQUAL =
    
32. 
    
33.             Scan s =new Scan();
    
34.             s.setFilter(filter1);
    
35.             ResultScanner rs =table.getScanner(s);
    
36. 
    
37.             for(Result r: rs){
    
38.                 System.out.println("rowkey:"+ new String(r.getRow()));
    
39.                 for(KeyValue keyValue: r.raw()){
    
40.                     System.out.println("列族:"+ new String(keyValue.getFamily())
    
41.                             +" 列:" + new String(keyValue.getQualifier())+ ":"
    
42.                             +new String(keyValue.getValue()));
    
43.                 }
    
44.             }
    
45. 
    
46.         }catch (IOException e){
    
47.             // TODO Auto-generated catch block
    
48.             e.printStackTrace();
    
49. 
    
50.         }
    
51. 
    
52.     }
    
53. 
    
54. }

相关的过滤方法使用:
提取rowkey以01结尾数据
Filter filter = new RowFilter(CompareFilter.CompareOp.EQUAL,new RegexStringComparator(".*01$"));

提取rowkey以包含201407的数据
Filter filter = new RowFilter(CompareFilter.CompareOp.EQUAL,new SubstringComparator("201407"));


提取rowkey以123开头的数据
Filter filter = new RowFilter(CompareFilter.CompareOp.EQUAL,new BinaryPrefixComparator("123".getBytes()));


-- The End --