You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Lars Hofhansl (JIRA)" <ji...@apache.org> on 2016/06/13 20:25:04 UTC
[jira] [Commented] (PHOENIX-2992) Remove ORDER BY from
COUNT(DISTINCT...)-only SELECT statements
[ https://issues.apache.org/jira/browse/PHOENIX-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328183#comment-15328183 ]
Lars Hofhansl commented on PHOENIX-2992:
----------------------------------------
Thinking on it more... Can we always remove all ORDER BY's when there are only aggregates?
I.e. it would also work for {{SELECT SUM(x) FROM T ORDER BY ...}} to simply remove the ORDER BY clause.
I suppose there might be order dependent aggregates...? Some of the window functions perhaps?
> Remove ORDER BY from COUNT(DISTINCT...)-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
>
>
> 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)