xinyiZzz commented on pull request #8695: URL: https://github.com/apache/incubator-doris/pull/8695#issuecomment-1080739125
> we do test on tpc-h with sf = 100 and 3 be with 64GB memory. q9, q12 and q21 failed on previous cost formula. > i don't think so. It is common that query submitted from programs. Programs cannot add hint by itself. But DBAs could set global variables according their cluster status. I understand your original intention~, it is reasonable to add a parameter to control the broadcast and shuffle types. Maybe we can hide `auto_broadcast_join_threshold` in normal times, and users only need to modify `mem_limit` in normal times. For example, this parameter defaults to 80% of `mem_limit`, 0% does not use broadcast, or other ideas. -- 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 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
