[
https://issues.apache.org/jira/browse/HIVE-21708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16835782#comment-16835782
]
Vineet Garg commented on HIVE-21708:
------------------------------------
It looks like HiveFilterJoinRule isn't able to push the filter on LEFT join
(before join re-ordering FILTER is on top of LEFT JOIN instead of on INNER
JOIN).
> Filter not pushed within join
> -----------------------------
>
> Key: HIVE-21708
> URL: https://issues.apache.org/jira/browse/HIVE-21708
> Project: Hive
> Issue Type: Bug
> Components: Query Planning
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
>
> {code:sql}
> explain cbo select count(*) from part where p_partkey <> ALL (select
> p_partkey from part)
> {code}
> {noformat}
> HiveAggregate(group=[{}], agg#0=[count()])
> HiveFilter(condition=[AND(OR(IS NULL($4), =($1, 0)), OR(IS NOT NULL($0),
> =($1, 0), IS NOT NULL($4)), OR(>=($2, $1), =($1, 0), IS NOT NULL($4), IS
> NULL($0)))])
> HiveProject(p_partkey=[$0], c=[$3], ck=[$4], p_partkey0=[$1], i826=[$2])
> HiveJoin(condition=[true], joinType=[inner], algorithm=[none],
> cost=[{27.0 rows, 0.0 cpu, 0.0 io}])
> HiveJoin(condition=[=($0, $1)], joinType=[left], algorithm=[none],
> cost=[{51.0 rows, 0.0 cpu, 0.0 io}])
> HiveProject(p_partkey=[$0])
> HiveTableScan(table=[[qtest, part]], table:alias=[part])
> HiveProject(p_partkey=[$0], i826=[true])
> HiveAggregate(group=[{0}])
> HiveFilter(condition=[IS NOT NULL($0)])
> HiveTableScan(table=[[qtest, part]], table:alias=[part])
> HiveProject(c=[$0], ck=[$1])
> HiveAggregate(group=[{}], c=[COUNT()], ck=[COUNT($0)])
> HiveTableScan(table=[[qtest, part]], table:alias=[part])
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
