colocate join 创建问题

[U_1691631787487_1332]

创建colocate join报错 colocate tables mush have same bucket num:0 是什么问题啊？

[yuchen1019]

@U_1691631787487_1332

colocate tables mush have same bucket num:0

什么版本的集群 麻烦发下对应的语句 感谢

[U_1691631787487_1332]

版本 3.0.2 , 3fe+3be 混部

建表语句：
create table a(
start_time bigint default null,
end_time bigint default null,
event_stamp bigint default null,
event_time datetime default null,
flow_id largeint default null,
src_ip varchar(256) default null,
dst_ip varchar(256) default null
) engine = olap
DUPLICATE KEY(start_time, end_time, event_stamp)
PARTITION BY date_trunc(‘hour’, event_time)
DISTRIBUTED BY HASH( flow_id)
PROPERTIES (
“replication_num” = “1”,
“bloom_filter_columns” = “src_ip, flow_id, dst_ip”,
“colocate_with” = “group_test”
);

create table b(
event_stamp bigint default null,
event_time datetime default null,
flow_id largeint default null,
flow_id_ba largeint default null,
file_name varchar(256) default null,
flow_src_ip varchar(256) default null,
flow_dst_ip varchar(256) default null
) engine = olap
DUPLICATE KEY(event_stamp)
PARTITION BY date_trunc(‘hour’, event_time)
DISTRIBUTED BY HASH( flow_id_ba)
PROPERTIES (
“replication_num” = “1”,
“bloom_filter_columns” = “flow_src_ip, file_name, flow_dst_ip”,
“colocate_with” = “group_test”
);

[U_1691631787487_1332]

@yuchen1019 麻烦看一下 谢谢~

[U_1691631787487_1332]

@yuchen1019 不确定是不是因为自动分桶的问题，手动设置了分桶数，就没问题了。

[jingdan]

是的，自动分桶的问题应该，colocate表当前不支持使用自动分桶，需要手动指定分桶个数，因为colocate需要确保分桶键和个数都一致