Vineet Garg created HIVE-21708: ---------------------------------- Summary: 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
{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)