planner: push StreamAgg down to IndexLookup when no group-by column
Open
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
When there is no group-by column, the planner should push `StreamAgg` down to `IndexLookup` and generate a plan like:
```
StreamAgg
IndexLookUp
IndexScan
StreamAgg
TableScan
```
Currently, `StreamAgg` cannot be pushed down if there is no `stream_agg()` hint, so we can only get a plan like:
```
StreamAgg
IndexLookUp
IndexScan
TableScan
```
Contributor guide
Assessment
This issue has not been assessed yet.