[HIVE-22263] MV rewriting for distinct and count(distinct) not being triggered

• Type: Sub-task
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO, Materialized views
• Assignee: Jesús Camacho Rodríguez
• Reporter: Steve Carlin
• Created: 27/Sep/19 21:22
• Updated: 27/Feb/24 22:23
• Resolved: 14/Feb/20 21:38

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;