doris-3.0 aggstate 建表报错

Viewed 34

Doris version doris-3.0.1 照文档操作,建表报错。

set enable_agg_state=true;
create table aggstate(
k1 int null,
k2 agg_state<sum(int)> generic,
k3 agg_state<group_concat(string)> generic
)
aggregate key (k1)
distributed BY hash(k1) buckets 3
properties("replication_num" = "1");

1726575593498.png

1 Answers

直接在mysql client上或者在doris manager 提供的webui上执行,自带的play ground不支持set 变量