You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2020/08/15 03:32:00 UTC

[jira] [Assigned] (HIVE-24041) Extend semijoin conversion rules

     [ https://issues.apache.org/jira/browse/HIVE-24041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez reassigned HIVE-24041:
----------------------------------------------


> 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)