[jira] [Created] (HIVE-22264) Degenerate case where mv not being used: computing aggregate on group by field

["Steve Carlin (Jira)" <ji...@apache.org>]

Steve Carlin created HIVE-22264:
-----------------------------------

             Summary: Degenerate case where mv not being used: computing aggregate on group by field
                 Key: HIVE-22264
                 URL: https://issues.apache.org/jira/browse/HIVE-22264
             Project: Hive
          Issue Type: Sub-task
          Components: CBO
    Affects Versions: 3.1.2
            Reporter: Steve Carlin
         Attachments: compensable.sql

This is a degenerate case, but still should work.  There is no reason to do a min(userid) when grouping by userid (should just use "userid" directly), but it should rewrite regardless

Script is attached.

Example:

create materialized view view1 stored as orc as select userid, sum(sales_amt) from base group by 1;

explain extended select min(userid) from base group by userid;



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