使用agg_state类型创建聚合表,提示SQL错误

Viewed 19

麻烦大佬看看,请问如何正确使用

CREATE TABLE IF NOT EXISTS dw.`dwd_user_portrait_agg`
(
    `app_id`                        SMALLINT NULL COMMENT '应用(游戏)ID',
    `user_id`                       BIGINT   NULL COMMENT '用户 ID',
    `first_server_id`               AGG_STATE<min_by(VARCHAR(64), BIGINT)> GENERIC NULL COMMENT '首次角色创建区服 ID'
) ENGINE = OLAP AGGREGATE KEY(`app_id`, `user_id`)
COMMENT '用户画像明细表'
DISTRIBUTED BY HASH(`app_id`, `user_id`) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);


image.png
image.png

1 Answers

在doris2.1.6测试可以创建成功
image.png