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)