You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hbase.apache.org by "qazwsx (Jira)" <ji...@apache.org> on 2024/06/03 12:57:00 UTC
[jira] [Updated] (HBASE-28634) There is a possibility that data cannot be obtained during reverse fuzzy query.
[ https://issues.apache.org/jira/browse/HBASE-28634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
qazwsx updated HBASE-28634:
---------------------------
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"))))}
!image-2024-06-03-14-26-57-645.png!
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"))))}
!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?
was:
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?
> 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
> Priority: Major
> 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 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"))))}
> !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)