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)

Reply via email to