Member since
11-03-2016
3
Posts
2
Kudos Received
0
Solutions
04-13-2017
07:42 PM
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.
... View more
04-11-2017
06:06 PM
1 Kudo
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.
... View more
Labels:
- Labels:
-
Apache HBase