phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Elser (Jira)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-6068) (5.x) Read repair reduces the number of rows returned for LIMIT queries
Date Mon, 10 Aug 2020 20:02:00 GMT

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

Josh Elser updated PHOENIX-6068:
--------------------------------
    Priority: Blocker  (was: Major)

> (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
>            Assignee: Kadir OZDEMIR
>            Priority: Blocker
>             Fix For: 4.16.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)

Mime
View raw message