Skip to content

Stop copying LogicalPlan and Exprs in SingleDistinctToGroupBy #10295

Closed

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

I don't think this pass does much copying at the moment, for whwat it is woth -- the benfit would be to follow the same pattern

Activity

  1. appletreeisyellow commented on May 13, 2024

    @appletreeisyellow
    Contributor

    I'd like to take this one if no one has worked on it yet

  2. alamb commented on May 13, 2024

    @alamb
    ContributorAuthor

    Thanks @appletreeisyellow -- that would be great. No one has started as far as I can tell.

  3. alamb commented on May 13, 2024

    @alamb
    ContributorAuthor

    I took a quick look at

    Looks to me like there are basically 2 things to do:

    1. Switch to use OptimizerRule::rewrite API (as in implement rewrite for FilterNullJoinKeys #10166)
    2. Remove the expr.clone() calls here
      (group_expr.clone(), (group_expr.clone(), None))

    Once you do 1. 2 should be pretty simple (maybe even just remove the .clone()

  4. appletreeisyellow commented on May 13, 2024

    @appletreeisyellow
    Contributor

    @alamb Thank you for the guidance!

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

Metadata

Metadata

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