ClickHouse / ClickHouse/ClickHouse
any loses LowCardinality
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
```sql
select cast ('', 'LowCardinality(Nullable(String))') x , toTypeName(x) x_type, toTypeName(any(x)) x_any_type;
┌─x─┬─x_type───────────────────────────┬─x_any_type───────┐
│ │ LowCardinality(Nullable(String)) │ Nullable(String) │
└───┴──────────────────────────────────┴──────────────────┘
create table t (
a Int64,
b SimpleAggregateFunction(any, Array(LowCardinality(Nullable(String)))) )
Engine = AggregatingMergeTree order by a;
DB::Exception: Incompatible data types between aggregate function 'any'
which returns Array(Nullable(String)) and column storage type Array(LowCardinality(Nullable(String))). (BAD_ARGUMENTS)
```
seems after 20.12
https://fiddle.clickhouse.com/7d7a5d39-f674-4145-9e2f-bf58916d3390
LowCardinality(Nullable(String)) LowCardinality(Nullable(String))
Contributor guide
Assessment
This issue has not been assessed yet.