Fixes and improve more for aggregation

[yl-lisen]

needs to be back ported from community:

- [ ] ClickHouse/ClickHouse#61257 (Fix possible incorrect result of aggregate function uniqExact #61257)
- [ ] ClickHouse/ClickHouse#61171 (Remove a few templates from Aggregator.cpp #61171)
- [ ] ClickHouse/ClickHouse#47399 (Remove distinct on top of MergingAggregatedStep #47399)
- [ ] ClickHouse/ClickHouse#44541 (Followup #43761 #44541)
- [ ] ClickHouse/ClickHouse#43761 (Refactor FunctionNode #43761)

• Revert "Merging #53757" ClickHouse/ClickHouse#58542 (Revert "Merging #53757" #58542)
  - [ ] JIT infrastructure refactoring ClickHouse/ClickHouse#50531 (JIT infrastructure refactoring #50531)
  - [ ] Better handling of NULL in aggregate combinators, fix possible segfault/logical error ClickHouse/ClickHouse#43813 (Better handling of NULL in aggregate combinators, fix possible segfault/logical error #43813)
  - [ ] JIT compilation float to bool conversion fix ClickHouse/ClickHouse#45067 (JIT compilation float to bool conversion fix #45067)
• uniqExact state parallel merging for distributed queries ClickHouse/ClickHouse#59009 (uniqExact state parallel merging for distributed queries #59009)
• Fix double destroy call on exception throw in addBatchLookupTable8 ClickHouse/ClickHouse#58745 (Fix double destroy call on exception throw in addBatchLookupTable8 #58745)
  - [ ] Better optimization of consecutive keys in aggregation ClickHouse/ClickHouse#57872 (Better optimization of consecutive keys in aggregation #57872)
• Improve hash table preallocation optimisation ClickHouse/ClickHouse#43945 (Improve hash table preallocation optimisation)
• Merging #53757 ClickHouse/ClickHouse#58440 (Enable JIT compilation for aggregation without key)
• Remove addBatchSinglePlaceFromInterval ClickHouse/ClickHouse#57258 (Remove addBatchSinglePlaceFromInterval #57258)
• WindowTransform decrease amount of virtual function calls ClickHouse/ClickHouse#56120 (WindowTransform decrease amount of virtual function calls #56120)
  - [ ] Avoid excessive allocation in Arena ClickHouse/ClickHouse#57074 (Avoid excessive allocation in Arena #57074)
• Experiment Aggregator merge and destroy states in batch ClickHouse/ClickHouse#53589 (Experiment Aggregator merge and destroy states in batch #53589)
  - [ ] Optimize group by constant keys ClickHouse/ClickHouse#53549 (Optimize group by constant keys #53549)
  - [ ] Add settings for real-time updates during query execution ClickHouse/ClickHouse#48607 (Add settings for real-time updates during query execution #48607)
• Fix memory consumption when max_block_size is huge in Aggregator + more memory checks ClickHouse/ClickHouse#51566 (Fix memory consumption when max_block_size is huge in Aggregator + more memory checks #51566)
• Convert hashSets in parallel before merge ClickHouse/ClickHouse#50748 (Convert hashSets in parallel before merge)
• Fix possible double-free in Aggregator ClickHouse/ClickHouse#52439 (Fix possible double-free in Aggregator #52439)
• JIT aggregation nullable key fix ClickHouse/ClickHouse#50291 (JIT aggregation nullable key fix #50291)
• Fix all key value is null and group use rollup return wrong answer ClickHouse/ClickHouse#49282 (Fix all key value is null and group use rollup return wrong answer #49282)
• Optimize one nullable key aggregate performance ClickHouse/ClickHouse#45772 (Optimize one nullable key aggregate performance #45772)
• Window view functional test failed on platform s390x ClickHouse/ClickHouse#45375 (Window view functional test failed on platform s390x)
• Fix GROUPING function SQL compatibility ClickHouse/ClickHouse#40762 (Fix GROUPING function SQL compatibility #40762)
• Prefetching in aggregation ClickHouse/ClickHouse#39304 (Prefetching in aggregation #39304)
• Control block size in aggregator ClickHouse/ClickHouse#39138 (Control block size in aggregator #39138)
• Quick fix for aggregation pipeline ClickHouse/ClickHouse#38295 (Quick fix for aggregation pipeline #38295)
• Improve 02354_distributed_with_external_aggregation_memory_usage ClickHouse/ClickHouse#39908 (Improve 02354_distributed_with_external_aggregation_memory_usage #39908)
• Improve memory usage during memory efficient merging of aggregation results ClickHouse/ClickHouse#39429 (Improve memory usage during memory efficient merging of aggregation results)
  - [ ] Preserve filling step plan position on sorting optimization ClickHouse/ClickHouse#37959 (Preserve filling step plan position on sorting optimization #37959)
  - [ ] Pushdown filter to the right side of sorting join ClickHouse/ClickHouse#39123 (Pushdown filter to the right side of sorting join #39123)
  - [ ] Move updateInputStream to ITransformingStep ClickHouse/ClickHouse#37393 (Move updateInputStream to ITransformingStep #37393)
  - [ ] Optimized processing of ORDER BY in window functions ClickHouse/ClickHouse#34632 (Optimized processing of ORDER BY in window functions #34632)
  - [ ] Functions calculation after sorting ClickHouse/ClickHouse#35623 (Functions calculation after sorting #35623)
  - [ ] Added JIT compilation of SortDescription ClickHouse/ClickHouse#34469 (Added JIT compilation of SortDescription #34469)
• Add GROUPING function ClickHouse/ClickHouse#37163 (Add GROUPING function #37163)
• Implement in order aggregation (optimize_aggregation_in_order) for projections for tables with fully materialized projections ClickHouse/ClickHouse#37469 (Implement in order aggregation (optimize_aggregation_in_order) for projections for tables with fully materialized projections #37469)
• Fix various issues when projection is enabled by default ClickHouse/ClickHouse#34305 (Fix various issues when projection is enabled by default #34305)
• Fix GROUP BY AggregateFunction ClickHouse/ClickHouse#37093 (Fix GROUP BY AggregateFunction #37093)

[yokofly]

add this one. https://github.com/ClickHouse/ClickHouse/pull/37020/files
I have seen we remove this useless code.
dc89297#diff-d6da13621eeabbd2e70bb09de71117a1168b2879f03a5fa05340989831a970ffL371