Hello all, I am working on an issue wherein one of the tpcds query is regressing when semijoin is also present with other inner joins in the query. Currently, DRILL uses LoptOptimizeJoinRule for join order optimization. During the debugging process, I observed that LoptOptimizeJoinRule is not considering semi joins for join order optimization. Please do let me know if my understanding is correct. If so what is the best option for handling this scenario?.
Thanks in advance. Regards, -Hanu
