phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maryann Xue (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2802) Merge sort usually not necessary for ORDERED aggregation
Date Tue, 05 Apr 2016 01:03:25 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15225443#comment-15225443
] 

Maryann Xue commented on PHOENIX-2802:
--------------------------------------

[~jamestaylor], sorry for jumping in late. The changes in SortMergeJoinIT and SubqueryUsingSortMergeJoinIT
should NOT be expected. The tables are already ordered on these keys (which are PK), so there
shouldn't be any sorting.

> Merge sort usually not necessary for ORDERED aggregation
> --------------------------------------------------------
>
>                 Key: PHOENIX-2802
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2802
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: James Taylor
>            Assignee: James Taylor
>             Fix For: 4.8.0
>
>         Attachments: PHOENIX-2802.patch, PHOENIX-2802_v2.patch
>
>
> Try something like the following query:
> {code}
> select pod, count(*) as orgs from organization group by pod order by pod desc;
> {code}
> versus this one:
> {code}
> select pod, count(*) as orgs from organization group by pod order by pod asc;
> {code}
> There may be some missing logic in how we setup the client-side order by in this case.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message