Improve aggregation code readability

[lewiszlw]

Is your feature request related to a problem or challenge?

I'm reading aggregation code recently, found it's hard to read due to different AggregateMode, these modes are mixed up in the code.

Describe the solution you'd like

Might split stream based on AggregateMode?

Describe alternatives you've considered

No response

Additional context

No response

[jayzhan211]

I think it is a good chance to add documentation that helps yourself and others, or refactor the code to improve the codebase.

[lewiszlw]

Yeah, I will try. I'm not familiar with the whole code yet, I'll keep reading.

[2010YOUY01]

This would be a valuable improvement. Now the execution behavior is determined by AggregateMode + other more subtle inner states like spill_state.xxx, and some functions will handle several less related paths at the same time, it's a good idea to separate them (or at least add more doc)
However if it's a big refactor, it's better to wait until #11943 gets merged to avoid conflicts

[Rachelint]

This would be a valuable improvement. Now the execution behavior is determined by AggregateMode + other more subtle inner states like spill_state.xxx, and some functions will handle several less related paths at the same time, it's a good idea to separate them (or at least add more doc) However if it's a big refactor, it's better to wait until #11943 gets merged to avoid conflicts

I think at least we should separate partial and the teminals(Final, Single...).
I am making a poc trying to improve the performance of partial, and I found it is too hard to make it, because all modes are mixed up...
I am worried that it will become unmaintainable in future...

[eejbyfeldt]

I was also reading the aggregation code and came up with one possible simplification. What do you think about the idea of a change like this #12517 I think it helps simplify the logic as it removes the is_stream_merging flag and lets that be handled as just another aggregation with final mode.

[Rachelint]

I was also reading the aggregation code and came up with one possible simplification. What do you think about the idea of a change like this #12517 I think it helps simplify the logic as it removes the is_stream_merging flag and lets that be handled as just another aggregation with final mode.

I guess it may be a bit confused? Because an aggr operator wraps another aggr operator.