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)