Problem Search data in HBASE.

[yoom nguyen]

We are having problems using filters to search for matching data in HBASE.
Here are our issues wondering if anyone can shed some light to our problem.

Compare value=011511607 in table Win2 to Comp2.  There should be three matches but it only show two matches.

Database's contents from two different tables:
hbase(main):002:0> scan 'Comp2', {COLUMN => 'mpnum:', FILTER => "ValueFilter(=, 'binaryprefix:011511607' )"}
ROW                                     COLUMN+CELL
 1                                      column=mpnum:, timestamp=1481301806687, value=011511607
 4                                      column=mpnum:, timestamp=1482117383212, value=011511607
 5                                      column=mpnum:, timestamp=1482117392043, value=011511607
3 row(s) in 0.0170 seconds

hbase(main):003:0> scan 'Win2', {COLUMN => 'mpnum:', FILTER => "ValueFilter(=, 'binaryprefix:011511607' )"}
ROW                                     COLUMN+CELL
 1                                      column=mpnum:, timestamp=1481301582336, value=011511607
1 row(s) in 0.0160 seconds

Below are the code that shown only two results.

First I am reading some data from one table and storing in a vector or arrayList:

        for (Result r : rs) {
            for (KeyValue kv : r.raw()) {
                if (new String(kv.getFamily()).equals("name")) {
                    temp = new String(kv.getValue());
                    x.addElement(temp);

                }
            }
        }

Then, I want to search a different table based on the values of this vector. I used filters to do this: (I tried binaryprefixComparator and binaryComparator as well)

     FilterList filterList = new FilterList(FilterList.Operator.MUST_PASS_ONE);    
    
        
        for (int c = 0; c < x.size(); c++) {
           System.out.println(x.get(c).toString());          
           filterList.addFilter(new SingleColumnValueFilter(Bytes.toBytes("name"), null, CompareOp.EQUAL, new SubstringComparator( x.get(c).toString()  )));
          
        }

I should get 3 results back, however I only get one result back, the first entry in the databse.
What doesnt make sense is that when I hardcode the value that I am looking for into my code, I will get all 3 results back.

I thought there might be some issue with converting the bytes to String and then back to bytes, but that would not explain how it was able to bring back the first result. For some reason, it is stopping at the first match and doesn't continue to find the other 2 rows that contain matching data. (but if I hardcode it i get the results?? such as:      x.addElement("abc123");    filterList.addFilter(new SingleColumnValueFilter(Bytes.toBytes("name"), null, CompareOp.EQUAL, new SubstringComparator( x.get(0).toString()  )));
)

Does anyone know what the problem is or what I need to do to resolve my issue? Your help is much appreciated.

Thank You
Yoom