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

Hudson commented on PHOENIX-2802:
---------------------------------

FAILURE: Integrated in Phoenix-master #1181 (See 
[https://builds.apache.org/job/Phoenix-master/1181/])
PHOENIX-2802 Merge sort usually not necessary for ORDERED aggregation (jtaylor: 
rev 15766625ab9a132f8d8ac625b026a5c56e62e879)
* 
phoenix-core/src/it/java/org/apache/phoenix/end2end/index/IndexExpressionIT.java
* phoenix-core/src/main/java/org/apache/phoenix/execute/AggregatePlan.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/HashJoinIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/index/LocalIndexIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/GroupByCaseIT.java
* 
phoenix-core/src/it/java/org/apache/phoenix/end2end/SubqueryUsingSortMergeJoinIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/SubqueryIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/SortMergeJoinIT.java


> 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)

Reply via email to