You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2019/09/27 21:21:00 UTC

[jira] [Created] (HIVE-22262) Aggregate pushdown through join may generate additional rewriting opportunities

Steve Carlin created HIVE-22262:
-----------------------------------

             Summary: Aggregate pushdown through join may generate additional rewriting opportunities
                 Key: HIVE-22262
                 URL: https://issues.apache.org/jira/browse/HIVE-22262
             Project: Hive
          Issue Type: Bug
          Components: CBO
    Affects Versions: 3.1.2
            Reporter: Steve Carlin
         Attachments: eager-v2.sql

In this case, there is a function used in the query and materialized view, but the aggregate is not being pushed down.  Script is attached.

Example query and materialized view:

 create materialized view av1 stored as orc as select fk1, fk2, fk3, to_date(fk4), sum(1) from fact group by 1, 2, 3, 4;

explain cbo select pk1, dim2.fk4, sum(1), count(c1)

from fact, dim2

where to_date(fact.fk4) = dim2.fk4

group by 1, 2

order by 1, 2;



--
This message was sent by Atlassian Jira
(v8.3.4#803005)