-
Notifications
You must be signed in to change notification settings - Fork 8.3k
LowCardinality can not be used with Parquet format #12086
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-datatype-wrapperType modifiers/wrappers (Nullable, LowCardinality, etc.).Type modifiers/wrappers (Nullable, LowCardinality, etc.).comp-formatsInput/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).Input/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).
Description
create table test_lc(a LowCardinality(String)) Engine = MergeTree order by tuple();
insert into test_lc values ('abcd');
select * from test_lc format Parquet;
Exception on client:
Code: 50. DB::Exception: The type "LowCardinality" of a column "a" is not supported for conversion into a Parquet data format
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.3.12 revision 54433.
Shorter version of the test:
select toLowCardinality('abcd') format Parquet;
Exception on client:
Code: 50. DB::Exception: The type "LowCardinality" of a column "toLowCardinality('abcd')" is not supported for conversion into a Parquet data format
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.3.12 revision 54433.
P.S. Insert works ok.
# clickhouse-client --query="select 'ab' as a format Parquet" | clickhouse-client --query="insert into test_lc format Parquet"
UPD: not ok with LowCardinality(Nullable(String)) (see comment).
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-datatype-wrapperType modifiers/wrappers (Nullable, LowCardinality, etc.).Type modifiers/wrappers (Nullable, LowCardinality, etc.).comp-formatsInput/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).Input/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).