[HBASE-28634] There is a possibility that data cannot be obtained during reverse fuzzy query.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.14
• Fix Version/s: 2.7.0, 3.0.0-beta-2, 2.5.11, 2.6.2
• Component/s: Filters
• Labels: pull-request-available

Language

Java

• Assignee: Dávid Paksy
• Reporter: qazwsx
• Created: 03/Jun/24 06:35
• Updated: 1 hour ago
• Resolved: Yesterday 09:18

Description

this is my example:

1.  

create 'abcd','f'

put 'abcd','111311','f:name','aaaaa'

put 'abcd','111444','f:name','aaaaa'

put 'abcd','111511','f:name','aaaaa'

put 'abcd','111611','f:name','aaaaa'

put 'abcd','111446','f:name','aaaaa'

put 'abcd','111777 ','f:name','aaaaa'

put 'abcd',' 111777','f:name','aaaaa'

 

2.  When I don't use the reversed query, I can get the data.

scan 'abcd', {FILTER => org.apache.hadoop.hbase.filter.FuzzyRowFilter.new(Arrays.asList(Pair.new(Bytes.toBytesBinary('111433'),Bytes.toBytesBinary("\xFF\xFF\xFF\xFF\x02\x02"))))}

 

3. When I use the reversed query, I can not get the data.

scan 'abcd', {REVERSED=>TRUE, FILTER => org.apache.hadoop.hbase.filter.FuzzyRowFilter.new(Arrays.asList(Pair.new(Bytes.toBytesBinary('111433'),Bytes.toBytesBinary("\xFF\xFF\xFF\xFF\x02\x02"))))}

 

4. 

The test shows that the following two issues may be related to this issue: HBASE-26232
How to reproduce the issue resolved by this issue?
Currently, I solve the fuzzy query by rolling back the code of this issue. Is there a better solution?

 

Issue Links

• is related to: HBASE-28621 PrefixFilter should use SEEK_NEXT_USING_HINT
• relates to: HBASE-12183 FuzzyRowFilter doesn't support reverse scans
• links to: GitHub Pull Request #6457
• links to: GitHub Pull Request #6482