What version of HBase are you on? If it is older than 0.90.2 ... it could be this: https://issues.apache.org/jira/browse/HBASE-3550 --Suraj
On Thu, May 3, 2012 at 12:18 AM, Davis <[email protected]> wrote: > Problem in combining filters. > following is a test code i executed.. > > FilterList listOfFilters = new FilterList (FilterList.Operator.MUST_PASS_ALL); > FilterList listOfFilters1 = new FilterList > (FilterList.Operator.MUST_PASS_ALL); > FilterList listOfFilters2 = new FilterList > (FilterList.Operator.MUST_PASS_ALL); > > SingleColumnValueFilter SingleFilter1 = new > SingleColumnValueFilter(Bytes.toBytes("cf"), > Bytes.toBytes("country"), CompareOp.EQUAL, > Bytes.toBytes("USA")); > listOfFilters.addFilter(SingleFilter1); > > ValueFilter VF1= new ValueFilter (CompareOp.EQUAL, > new SubstringComparator("ABC")); > ColumnPrefixFilter CF1= new ColumnPrefixFilter(Bytes.toBytes("name")); > listOfFilters1.addFilter(CF1); > listOfFilters1.addFilter(VF1); > listOfFilters.addFilter(listOfFilters1); > > ValueFilter VF2= new ValueFilter (CompareOp.EQUAL, > new SubstringComparator("ED")); > ColumnPrefixFilter CF2= new ColumnPrefixFilter (Bytes.toBytes("CRS")); > listOfFilters2.addFilter(CF2); > listOfFilters2.addFilter(VF2); > listOfFilters.addFilter(listOfFilters2); > > When i do a combibation of SingleFilter1 and listOfFilters1 > the result is correct, same way the combination of > SingleFilter1 and listOfFilters2 is returing correct result. > But when all the three is combined im not getting any result.. > > Is it the problem with multiple ColumnPrefixFilter??? > Value "ABC" exist in name.0 and value "ED" exist in CRS.0 and it is in > the same row under same Column Family. >
