You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/02/08 20:55:39 UTC
[jira] [Commented] (PHOENIX-2665) index split while running group
by query is returning duplicate results
[ https://issues.apache.org/jira/browse/PHOENIX-2665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15137566#comment-15137566 ]
James Taylor commented on PHOENIX-2665:
---------------------------------------
[~rajeshbabu] - can you post the schema, query, and explain plan too? I suspect it's when the GroupedAggregateRegionObserver.scanOrdered() code path is taken, since the region lock is not take for the entire traversal of rows as it is in the scanUnordered code path.
> index split while running group by query is returning duplicate results
> -----------------------------------------------------------------------
>
> Key: PHOENIX-2665
> URL: https://issues.apache.org/jira/browse/PHOENIX-2665
> Project: Phoenix
> Issue Type: Bug
> Reporter: Rajeshbabu Chintaguntla
> Assignee: Rajeshbabu Chintaguntla
> Priority: Blocker
> Fix For: 4.7.0
>
>
> When there is a index split while running group by query is returning duplicate results.
> Instead of returning 500,000 records it's returning 729,500 records.
> {noformat}
> +------------------------------------------+------------------------------------------+
> | 4999 | 499999 |
> +------------------------------------------+------------------------------------------+
> 500,000 rows selected (11.996 seconds)
> {noformat}
> {noformat}
> +------------------------------------------+------------------------------------------+
> | 4999 | 499999 |
> +------------------------------------------+------------------------------------------+
> 729,500 rows selected (15.291 seconds)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)