[
https://issues.apache.org/jira/browse/HIVE-22264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-22264:
-------------------------------------------
Component/s: Materialized views
> 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, Materialized views
> Affects Versions: 3.1.2
> Reporter: Steve Carlin
> Priority: Major
> 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)
