【StarRocks版本】2.4.1
根据官网新建两张表，同一t1组
CREATE TABLE t1 (
id int(11) COMMENT “”,
value varchar(8) COMMENT “”
) ENGINE = OLAP
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES (
“colocate_with” = “t1”
);
CREATE TABLE t2 (
id int(11) COMMENT “”,
value varchar(8) COMMENT “”
) ENGINE = OLAP
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES (
“colocate_with” = “t1”
);
explain
SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.id;
Colocate Join 没有效果，没有false