[HIVE-22259] Rewriting fails for `BETWEEN` clauses with different ranges in MV and query

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• 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 20:59
• Updated: 27/Feb/24 22:23
• Resolved: 04/May/20 19:59

Description

Script attached.

The following query does not rewrite:

create materialized view view9 stored as orc as (select prod_id, cust_id, store_id, sale_date, qty, amt, descr from sales where cust_id >= 1 and prod_id < 31);

 

– this is not ok

explain extended select  * from sales where cust_id between 1 and 20 and prod_id < 31;

Issue Links

• is part of: HIVE-22256 Rewriting fails when `IN` clause has items in different order in MV and query