ClickHouse / ClickHouse/ClickHouse
`arrayFilter` and `group by all` don't play nice together
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
On latest version (23.9.2) `arrayFilter` and `group by all` don't play nice together. Potentially this is the case for other array functions as well.
https://fiddle.clickhouse.com/db484582-99d9-46d9-8d20-a5cdbab32933
Does not work:
```sql
select
'bar' as foo,
arrayFilter(x-> x>0, groupArray(number))
from (select number from system.numbers limit 5)
group by all
```
When using `group by all` the error `Code: 46. DB::Exception: Received from localhost:9000. DB::Exception: Unknown function lambda. (UNKNOWN_FUNCTION)` is shown.
Works:
```sql
select
'bar' as foo,
arrayFilter(x-> x>0, groupArray(number))
from (select number from system.numbers limit 5)
group by foo
```
Contributor guide
Assessment
This issue has not been assessed yet.