englefly commented on code in PR #64605: URL: https://github.com/apache/doris/pull/64605#discussion_r3449466378
########## regression-test/data/query_p0/hint/test_leading.out: ########## @@ -2151,12 +2151,11 @@ PhysicalResultSink --hashAgg[GLOBAL] ----PhysicalDistribute[DistributionSpecGather] -------hashAgg[LOCAL] ---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3)) otherCondition=() Review Comment: 建议将 groovy里的 "select count(*)" 改为 "select *" 这组case是测试 join order, 但报错都是因为agg 的选择算法改变导致的, 应该尽量排除其他干扰 另外一个干扰因素是 join 的shuffle 类型, 建议 set BROADCAST_ROW_COUNT_LIMIT=0, 全部使用shuffle join, 避免broad cast join的干扰 -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
