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

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

James Taylor created PHOENIX-1847:
-------------------------------------

             Summary: Order GROUP BY key to match ORDER BY key if it's a subset or 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)