[ https://issues.apache.org/jira/browse/HIVE-24041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-24041: ------------------------------------------- Status: Patch Available (was: Open) > Extend semijoin conversion rules > -------------------------------- > > Key: HIVE-24041 > URL: https://issues.apache.org/jira/browse/HIVE-24041 > Project: Hive > Issue Type: Improvement > Components: CBO > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > > This patch fixes a couple of limitations that can be seen in > {{cbo_query95.q}}, in particular: > - It adds a rule to trigger semijoin conversion when the there is an > aggregate on top of the join that prunes all columns from left side, and the > aggregate operator is on the left input of the join. > - It extends existing semijoin conversion rules to prune the unused columns > from its left input, which leads to additional conversion opportunities. -- This message was sent by Atlassian Jira (v8.3.4#803005)