[HBASE-20151] Bug with SingleColumnValueFilter and FamilyFilter

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Abandoned
• Affects Version/s: 2.1.0, 2.0.1, 1.4.5

Environment

MacOS 10.13.3

HBase 1.3.1

• Assignee: Unassigned
• Reporter: Steven Sadowski
• Created: 07/Mar/18 21:01
• Updated: 11/Jun/22 19:08
• Resolved: 11/Jun/22 19:08

Description

When running the following queries, the result is sometimes return correctly and other times incorrectly based on the qualifier queried.

Setup:

create 'test', 'a', 'b'
test = get_table 'test'

test.put '1', 'a:1', nil
test.put '1', 'a:10', nil
test.put '1', 'b:2', nil

 
This query works fine when the SCVF's qualifier has length 1 (i.e. '1') :

test.scan({ FILTER => "( SingleColumnValueFilter('a','1',=,'binary:',true,true) AND FamilyFilter(=,'binary:b') )"})
ROW                                       COLUMN+CELL
 1                                        column=b:2, timestamp=1520455888059, value=
1 row(s) in 0.0060 seconds

 

The query should return the same result when passed a qualifier of length 2 (i.e. '10') :

test.scan({ FILTER => "( SingleColumnValueFilter('a','10',=,'binary:',true,true) AND FamilyFilter(=,'binary:b') )"})
ROW                                       COLUMN+CELL
0 row(s) in 0.0110 seconds

However, in this case, it does not return any row (expected result would be to return the same result as the first query).

 

Removing the family filter while the qualifier is '10' yields expected results:

test.scan({ FILTER => "( SingleColumnValueFilter('a','10',=,'binary:',true,true) )"})
ROW                                       COLUMN+CELL
 1                                        column=a:1, timestamp=1520455887954, value=
 1                                        column=a:10, timestamp=1520455888024, value=
 1                                        column=b:2, timestamp=1520455888059, value=
1 row(s) in 0.0140 seconds

 

 

Issue Links

• is related to: HBASE-13122 Improve efficiency for return codes of some filters
• links to: Review Board