[MCOL-4558] Need to flatten (merge) queries that can be flattened (merged) Created: 2021-02-24 Updated: 2023-12-15 |
|
| Status: | Open |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 23.10 |
| Type: | Task | Priority: | Major |
| Reporter: | Gregory Dorman (Inactive) | Assignee: | Roman |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Epic Link: | Columnstore - Technical debts in Optimizer / Rewriter |
| Description |
|
we need to rewrite select count(col) from (select * from table); It has to become select count(col) from table. Today, it is backwards. PMs send rows to one exemgr to do aggregation. Orders of magnitude worse. |