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

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.2
• Component/s: CBO, Materialized views
• Assignee: Unassigned
• Reporter: Steve Carlin
• Created: 27/Sep/19 21:25
• Updated: 27/Sep/19 23:20

Description

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;