Hi Team,

Currently I am trying to use MultipleColumnPrefixFilter along with
SingleColumnValueFilter and the results  that I am getting seems to be
problematic.

I have an hbase table "test_messages" with column family  "main" and Column
Qualifiers as : "pa", "cs" ,"eps","cst","ver","nm","parl".
Assume all the row Keys of the table  has all the above columns.


Now When I am creating Filters as below:

FilterList temp=new FilterList(FilterList.Operator.MUST_PASS_ALL);

SingleColumnValueFilter filter1= new SingleColumnValueFilter("main"
,"pa",CompareFilter.CompareOp.LESS_OR_EQUAL, Bytes.toBytes("SomeValue"));
filter1 .setFilterIfMissing(true);

SingleColumnValueFilter filter2= new SingleColumnValueFilter("main"
,"cs",CompareFilter.CompareOp.EQUAL, Bytes.toBytes("SomeValue"));
filter2.setFilterIfMissing(true);


SingleColumnValueFilter filter3= new SingleColumnValueFilter("main"
,eps",CompareFilter.CompareOp.EQUAL, Bytes.toBytes("SomeValue"));
filter3.setFilterIfMissing(true);

temp.addFilter(filter1);

temp.addFilter(filter2);

temp.addFilter(filter3);

Case 1:

MultipleColumnPrefixFilter cpfxf=new MultipleColumnPrefixFilter(new
byte[][]{ Bytes.toBytes("pa"),Bytes.toBytes("cs"),Bytes.toBytes("eps")});
temp.addFilter(cpfxf); The above filters results in proper extratcion of
data from Hbase. Now if I create a MultipleColumnPrefixFilter as below:
Case 2:
Consider we have filter1,2,3 and below filter

MultipleColumnPrefixFilter cpfxf=new MultipleColumnPrefixFilter(new
byte[][]{ Bytes.toBytes("pa"),Bytes.toBytes("eps")}); //Note "cs" is
removed temp.addFilter(cpfxf); I don't get any data However if I create a
filter as Case 3:

Consider we have filter1,2,3 and below filter

MultipleColumnPrefixFilter cpfxf=new MultipleColumnPrefixFilter(new
byte[][]{ Bytes.toBytes("pa"),Bytes.toBytes("cs")}); // Note "eps" is
removed and "cs" is added back. temp.addFilter(cpfxf); I get lot of data.
EIther both Case 2 and Case 3 should give data or none of them. Can someone
Explain me the reason for this to happen ? Or is there a bug in
MultipleColumnPrefixFilter .

Hbase Version: 1.2.0



-- 
Vikash Agarwal

Reply via email to