HBase - Use of FilterList MUST_PASS_ALL

[#1]

Hi,

Can someone clear up how the Filter List works in HBase. My thinking was all filters much pass for the row to return, for example:

{"type":"FilterList","op":"MUST_PASS_ALL","filters":[ {"type":"SingleColumnValueFilter","op":"EQUAL","family":"ACTY","qualifier":"ACCT_ID","latestVersion":true,"comparator":{"type":"BinaryComparator","value":"C000123"}}, {"type":"SingleColumnValueFilter","op":"EQUAL","family":"ACTY","qualifier":"IP_ID","latestVersion":true,"comparator":{"type":"BinaryComparator","value":"100"}}, {"type":"SingleColumnValueFilter","op":"EQUAL","family":"ACTY","qualifier":"OFF_ID","latestVersion":true,"comparator":{"type":"BinaryComparator","value":"V00"}}, {"type":"SingleColumnValueFilter","op":"EQUAL","family":"ACTY","qualifier":"IBD_ID","latestVersion":true,"comparator":{"type":"BinaryComparator","value":"C01"}} ] }

However, in the above example, it is returning data that matches the first Value (ACCT_ID) and ignore the other constraints. What am I missing about how the query is constructed, how am I using MUST_PASS_ALL wrong?

Thanks.

[#2 · Accepted solution]

@Stephen knott

Are filter columns part of scan? If filter columns are not part of scan then filters are ignored. Check the following link:

https://issues.apache.org/jira/browse/HBASE-4364

[#3]

Thank you.

You are correct, I wasn't populating the Scanner object with columns, add them in:

<Scanner><column>mycolumn</column><column>mycolumn2</column><filter>...

and it works. Thanks.