[
https://issues.apache.org/jira/browse/PHOENIX-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328589#comment-15328589
]
James Taylor commented on PHOENIX-2992:
---------------------------------------
+1 for v1. The AVG compiles to two aggregators - a count and a sum, so your
test is correct and still not adding another aggregator for the ORDER BY part.
> Remove ORDER BY from aggregate-only SELECT statements
> -----------------------------------------------------
>
> Key: PHOENIX-2992
> URL: https://issues.apache.org/jira/browse/PHOENIX-2992
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Lars Hofhansl
> Assignee: Lars Hofhansl
> Fix For: 4.8.0
>
> Attachments: 2989-orderby-v3.txt, 2992-v1.txt
>
>
> In PHOENIX-2989 we observe that any ORDER BY clause can simply be removed
> from any statement that only SELECTs on COUNT(DISTINCT ...)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
