Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
3.1.2
-
None
-
None
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;