You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem or challenge?
When the column which is the output ordering of the input plan of a projection disappears after the projection, the order information is lost. Therefore, unnecessary SortExecs may be added.
For example, if the input plan has an output ordering of column 'a', and there is a projection of 'a+1', the order requirement of 'a' is still satisfied.
Describe the solution you'd like
We can estimate the new expressions' orders by using the input plan output ordering and equivalence properties, and in the case of dropping the output ordering, we can assign one of them as the new output ordering.
Describe alternatives you've considered
No response
Additional context
No response
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem or challenge?
When the column which is the output ordering of the input plan of a projection disappears after the projection, the order information is lost. Therefore, unnecessary SortExecs may be added.
For example, if the input plan has an output ordering of column 'a', and there is a projection of 'a+1', the order requirement of 'a' is still satisfied.
Describe the solution you'd like
We can estimate the new expressions' orders by using the input plan output ordering and equivalence properties, and in the case of dropping the output ordering, we can assign one of them as the new output ordering.
Describe alternatives you've considered
No response
Additional context
No response
The text was updated successfully, but these errors were encountered: