You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org> on 2016/02/10 22:10:18 UTC

[jira] [Resolved] (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:all-tabpanel ]

Rajeshbabu Chintaguntla resolved PHOENIX-2665.
----------------------------------------------
    Resolution: Fixed

Pushed to master, 4.x branches. Thanks for review [~jamestaylor].

> 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
>
>         Attachments: PHOENIX-2665.patch
>
>
> 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)