麻烦大佬看看,请问如何正确使用
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"
);