Skip to content

Stop copying LogicalPlan and Exprs in ScalarSubqueryToJoin #10294

Description

@alamb

Is your feature request related to a problem or challenge?

Part of #9637

As part of making the planner faster, we are updating the optimizer passes to avoid copying LogicalPlan and Expr (see #9637)

Describe the solution you'd like

I would like to reduce the amount of copying in this pass (even though it doesn't appear in current profiling)

Describe alternatives you've considered

Apply the model from @Lordworms in #10166 to this pass
2. Update OptimizerRule::supports_rewrite` to return true

  1. Update OptimizerRule to use rewrite
  2. Update the pass itself to not copy the LogicalPlan (ideally using the TreeNode API) - it is implemented for LogicalPlan (API) and Expr (API)

Other examples: #10218

Additional context

Activity

  1. rtadepalli commented on May 7, 2024

    @rtadepalli

    take

  2. alamb commented on May 13, 2024

    @alamb
    ContributorAuthor

    Since this one is a bit tricky and I don't see any draft PRs yet, I am going to take a shot at a PR as well

  3. rtadepalli commented on May 14, 2024

    @rtadepalli

    Well.. I was finishing up going through the Rust book and that took more than expected because other things came up. I'll pick up another ticket, sorry about the delay.

  4. alamb commented on May 14, 2024

    @alamb
    ContributorAuthor

    Well.. I was finishing up going through the Rust book and that took more than expected because other things came up. I'll pick up another ticket, sorry about the delay.

    No worries -- I think this is a pretty tough first PR to work on. I made a PR to do it here: #10489

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions