Details
-
Sub-task
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
3.1.2
-
None
Description
Count distinct issues with materialized views. Two scripts attached
1)
create materialized view base_aview stored as orc as select distinct c1 c1, c2 c2 from base;
explain extended select count(distinct c1) from base group by c2 ;
2)
create materialized view base_aview stored as orc as SELECT c1 c1, c2 c2, sum(c2) FROM base group by 1,2;
explain extended select count(distinct c1) from base group by c2;