[jira] [Updated] (PHOENIX-1847) Order GROUP BY key to match ORDER BY key if it's a subset of the expressions

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-1847:
----------------------------------
    Summary: Order GROUP BY key to match ORDER BY key if it's a subset of the expressions  (was: Order GROUP BY key to match ORDER BY key if it's a subset or expressions)

> Order GROUP BY key to match ORDER BY key if it's a subset of the expressions
> ----------------------------------------------------------------------------
>
>                 Key: PHOENIX-1847
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1847
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: James Taylor
>
> An ORDER BY for an aggregate query is executed on the client-side. We can optimize the ORDER BY out if the GROUP BY expressions are a subset of the ORDER BY expressions (taking into account ASC/DESC and NULL FIRST/LAST). We'd need to do a pass to re-order the GROUP BY based on the ORDER BY, since the GROUP BY is compiled first.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)