[
https://issues.apache.org/jira/browse/PHOENIX-5969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kadir OZDEMIR updated PHOENIX-5969:
-----------------------------------
Attachment: PHOENIX-5969.4.x.002.patch
> Read repair reduces the number of rows returned for LIMIT queries
> -----------------------------------------------------------------
>
> Key: PHOENIX-5969
> URL: https://issues.apache.org/jira/browse/PHOENIX-5969
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0, 4.14.3
> Reporter: Kadir OZDEMIR
> Assignee: Kadir OZDEMIR
> Priority: Major
> Attachments: PHOENIX-5969.4.x.001.patch, PHOENIX-5969.4.x.002.patch
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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)
