Userwhite commented on issue #6066: URL: https://github.com/apache/incubator-doris/issues/6066#issuecomment-867445649
> @EmmyMiao87 > 以及一个问题：我发现colocateAgg没有成功执行： > 表结构如下： > CREATE TABLE `t1` ( > `k1` int(11) NULL COMMENT "", > `k2` int(11) NULL COMMENT "", > `k3` int(11) NULL COMMENT "", > `v1` int(11) NULL COMMENT "", > `v2` int(11) NULL COMMENT "" > ) ENGINE=OLAP > UNIQUE KEY(`k1`, `k2`, `k3`) > COMMENT "OLAP" > DISTRIBUTED BY HASH(`k1`, `k2`) BUCKETS 10 > PROPERTIES ( > "replication_num" = "1", > "colocate_with" = "group1", > "in_memory" = "false", > "storage_format" = "V2" > ); > 表t2和表t1一致； > 对于以下的sql： > explain select count(1) from t1 group by t1.k1,t1.k2; > explain select count(1) from t1 join t2 on t1.k1 = t2.k1 and t1.k2 = t2.k2 group by t1.k1,t1.k2; > > 都没有消除merge finalize这一步，可能的原因是：columnEqual的时候，由于Groupby字段的tablename没有带db，而dataPartition是带了的，所以两者不相等。 此处是针对master的最新代码 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
