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

["qazwsx (Jira)" <ji...@apache.org>]

qazwsx created HBASE-28634:
------------------------------

             Summary: There is a possibility that data cannot be obtained during reverse fuzzy query.
                 Key: HBASE-28634
                 URL: https://issues.apache.org/jira/browse/HBASE-28634
             Project: HBase
          Issue Type: Bug
    Affects Versions: 2.4.14
            Reporter: qazwsx
         Attachments: image-2024-06-03-14-26-57-645.png, image-2024-06-03-14-27-17-516.png

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"))))}

!image-2024-06-03-14-26-57-645.png!

 

3. When I use the reversed query, I can 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"))))}

!image-2024-06-03-14-27-17-516.png!

 

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?

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)