hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20826) Enhance HiveSemiJoin rule to convert join + group by on left side to Left Semi Join
Date Thu, 01 Nov 2018 00:54:00 GMT

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

Vineet Garg updated HIVE-20826:
-------------------------------
    Attachment: HIVE-20826.1.patch

> Enhance HiveSemiJoin rule to convert join + group by on left side to Left Semi Join
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-20826
>                 URL: https://issues.apache.org/jira/browse/HIVE-20826
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>         Attachments: HIVE-20826.1.patch
>
>
> Currently HiveSemiJoin rule looks for pattern where group by is on right side.
> We can convert joins which have group by on left side (assuming group by keys are same
as join keys and none of the columns are being projected from left side) to LEFT SEMI JOIN
by swapping the inputs. e.g. queries such as:
> {code:sql}
> explain select pp.p_partkey from (select distinct p_name from part) p join part pp on
pp.p_name = p.p_name;
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message