ClickHouse / ClickHouse/ClickHouse
GROUP BY push down optimization
Open
comp-query-optimizer
feature
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
With UNION:
```sql
select
x, sum(y)
from (
select x, y
from t1
union all
select x, y
from t2
)
group by x
```
With ARRAY JOIN
```sql
select x, sum(y)
from (
select x, yArr
from t
array join yArrArr as yArr
)
array join yArr as y
group by x
```
Contributor guide
Assessment
This issue has not been assessed yet.