Skip to content

[C++] Support order by derived column #31982

Closed

Description

@asfimport

You can't do the equivalent of

SELECT x, y FROM table ORDER BY x * y ASC;

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.

Reporter: Neal Richardson / @nealrichardson

Note: This issue was originally created as ARROW-16631. Please see the migration documentation for further details.

Activity

  1. added a commit that references this issue on May 11, 2023
    590f98c
  2. added a commit that references this issue on May 15, 2023
    b142044
  3. added a commit that references this issue on Feb 20, 2024
    47a602d
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions