ClickHouse / ClickHouse/ClickHouse

`arrayFilter` and `group by all` don't play nice together

Open
#56,019 5 comments 3 reactions 0 assignees View on GitHub
comp-query-analyzer external unexpected behaviour
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.