FrankZhang996 opened a new issue, #16858: URL: https://github.com/apache/doris/issues/16858
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.1.5 ### What's Wrong? select sum(t1.指标1), t1.维度1, t1.维度2, t1.维度3 from fin_dw.table1 t1 join fin_dim.table2 t2 on ( .... ) group by t1.维度1, t1.维度2, t1.维度3 table1数据量10亿左右，table2数据量2.5亿左右，doris优化器选择的join方式是broadcast table2，会导致查询超时。 ### What You Expected? 右表数据量比较大时，不要采用broadcast，要使用shuffle的join方式。 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
