Jesus Camacho Rodriguez created HIVE-24041: ----------------------------------------------
Summary: 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 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)