[jira] [Created] (ARROW-16631) [C++] Support order by derived column

["Neal Richardson (Jira)" <ji...@apache.org>]

Neal Richardson created ARROW-16631:
---------------------------------------

             Summary: [C++] Support order by derived column
                 Key: ARROW-16631
                 URL: https://issues.apache.org/jira/browse/ARROW-16631
             Project: Apache Arrow
          Issue Type: Improvement
          Components: C++
            Reporter: Neal Richardson


You can't do the equivalent of

{code}
SELECT x, y FROM table ORDER BY x * y ASC;
{code}

because sorting requires a named column AND because sorting is only done in a SinkNode. You can project to {x, y, x*y} then sort on x*y, but you can't then project back to {x, y} on the sorted data because that's a new ExecPlan and order is not preserved. In R we have to handle this outside of an ExecPlan.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)