XorSum commented on issue #1693: URL: https://github.com/apache/auron/issues/1693#issuecomment-3615125031
> [@XorSum](https://github.com/XorSum) It is indeed a bug. > > But your test sql here is not little extreme that tmp_t1.a and tmp_t2.a have only one value: 0, then all the records from both table (10000 x 10000) matches together. > > Can you share your real scenario you met in real life query? In our cluster, there are indeed some SQL queries where extreme duplication of join keys leads to a significant data volume. This bug was initially discovered in such SQL queries. These scenarios typically arise from two causes: - Unintentional – where data engineers accidentally miss certain join conditions during development. - Intentional – where such a join pattern is designed to meet specific business requirements. Since it is not easy to distinguish between unintentional and intentional causes, ensuring these SQL queries run successfully whenever possible will enhance Auron’s robustness, resilience, and user experience. -- 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]
