[jira] [Created] (HIVE-21708) Filter not pushed within join

["Vineet Garg (JIRA)" <ji...@apache.org>]

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)