HBase - Use of FilterList MUST_PASS_ALL

stephen_knott — Wed, 12 Apr 2017 01:06:05 GMT

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.

Re: HBase - Use of FilterList MUST_PASS_ALL

mqureshi — Wed, 12 Apr 2017 05:35:53 GMT

@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

Re: HBase - Use of FilterList MUST_PASS_ALL

stephen_knott — Fri, 14 Apr 2017 02:42:14 GMT

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.

question Re: HBase - Use of FilterList MUST_PASS_ALL in Archives of Support Questions (Read Only)

HBase - Use of FilterList MUST_PASS_ALL

Re: HBase - Use of FilterList MUST_PASS_ALL

Re: HBase - Use of FilterList MUST_PASS_ALL