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] [Assigned] (HIVE-18008) Add optimization rule to remove gby from right side of left semi-join
Date Wed, 08 Nov 2017 00:01:00 GMT

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

Vineet Garg reassigned HIVE-18008:
----------------------------------


> Add optimization rule to remove gby from right side of left semi-join
> ---------------------------------------------------------------------
>
>                 Key: HIVE-18008
>                 URL: https://issues.apache.org/jira/browse/HIVE-18008
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Planning
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>
> Group by (on same keys as semi join) as right side of Left semi join is unnecessary and
could be removed. We see this pattern in subqueries with explicit distinct keyword e.g.
> {code:sql}
> explain select * from src b where b.key in (select distinct key from src a where a.value
= b.value)
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message