You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Istvan Toth (Jira)" <ji...@apache.org> on 2020/11/24 10:22:00 UTC

[jira] [Resolved] (PHOENIX-6068) (5.x) Read repair reduces the number of rows returned for LIMIT queries

     [ https://issues.apache.org/jira/browse/PHOENIX-6068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Istvan Toth resolved PHOENIX-6068.
----------------------------------
    Resolution: Fixed

This was resolved as part of the indexing rebase.

The changes and the test are in master now, and the test passes.

> (5.x) Read repair reduces the number of rows returned for LIMIT queries
> -----------------------------------------------------------------------
>
>                 Key: PHOENIX-6068
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6068
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.0.0, 4.14.3
>            Reporter: Kadir OZDEMIR
>            Priority: Blocker
>             Fix For: 5.1.0
>
>
> Phoenix uses HBase PageFilter to limit the number of rows returned by scans. If a scanned index row is unverified, GlobalIndexChecker repairs this rows. This repair operation leads to either skipping the unverified row or scanning its repaired version. Every scanned row including unverified rows are counted by the page filter. Since unverified rows are counted but not returned for the query, the actual number of rows returned for a LIMIT query becomes less than the set limit (i.e., page size) for the query.  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)