[ 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)