[GitHub] [incubator-doris] wutiangan opened a new issue #4149: choose broadcastjoin first when cardinality cannot be estimated

[GitBox <gi...@apache.org>]

wutiangan opened a new issue #4149:
URL: https://github.com/apache/incubator-doris/issues/4149


   sql：
   `select * from (select k1 from jointest group by k1)t2, jointest t1 where t1.k1 = t2.k1`
   
   reason:
   In version 0.11, the SQL choose broadcastjoin and returns it in 9s. However, in version 0.12, the SQL choose shuffle join and runs 32S.
   When the cardinality cannot be estimated, it is better to choose broadcast join first. When there is a performance bottleneck, users can manually add hint to shuffle point.


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [incubator-doris] kangkaisen closed issue #4149: [BUG] choose broadcastjoin first when cardinality cannot be estimated

[GitBox <gi...@apache.org>]

kangkaisen closed issue #4149:
URL: https://github.com/apache/incubator-doris/issues/4149


   


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org