Open vzubriichuk opened 6 months ago
Cannot summarize values in column that has nullable type
Steps to reproduce the behavior:
Create table CREATE TABLE db.nullable_table ( ID Int16, Kolvo Nullable(Int16) ) ENGINE = MergeTree() ORDER BY tuple();
CREATE TABLE db.nullable_table ( ID Int16, Kolvo Nullable(Int16) ) ENGINE = MergeTree() ORDER BY tuple();
Insert values INSERT INTO db.nullable_table VALUES (1,10),(2,20),(3,null);
INSERT INTO db.nullable_table VALUES (1,10),(2,20),(3,null);
Add table to PowerBI report, an error occurs when trying to create any visualized object that aggregates values from the Kolvo field
select sum(cast(
as DOUBLE)) as
from
.
Cannot summarize values in column that has nullable type
Steps to reproduce the behavior:
Create table
CREATE TABLE db.nullable_table ( ID Int16, Kolvo Nullable(Int16) ) ENGINE = MergeTree() ORDER BY tuple();Insert values
INSERT INTO db.nullable_table VALUES (1,10),(2,20),(3,null);Add table to PowerBI report, an error occurs when trying to create any visualized object that aggregates values from the Kolvo field
select sum(cast(Kolvoas DOUBLE)) asC1fromdb.nullable_table``Configuration
Environment