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/06/13 23:27:57 UTC
[jira] [Commented] (PHOENIX-2992) Remove ORDER BY from
aggregate-only SELECT statements
[ 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)