[HIVE-22256] Rewriting fails when `IN` clause has items in different order in MV and query

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO, Materialized views
• Labels: pull-request-available
• Assignee: Jesús Camacho Rodríguez
• Reporter: Steve Carlin
• Created: 27/Sep/19 20:49
• Updated: 27/Feb/24 22:23
• Resolved: 04/May/20 19:58

Description

Rewriting fails on following materialized view and query (script is also attached):

create materialized view view2 stored as orc as (select prod_id, cust_id, store_id, sale_date, qty, amt, descr from sales where cust_id in (1,2,3,4,5));

explain extended select prod_id, cust_id  from sales where cust_id in (5,1,2,3,4);

Issue Links

• fixes: HIVE-22806 Missing materialized view rewrite in case the filter is further narrowed
• fixes: HIVE-20473 Optimization for materialized views
• incorporates: HIVE-22258 Rewriting fails for `IN` clauses in MV and query when we use equals or subset in the query
• incorporates: HIVE-22259 Rewriting fails for `BETWEEN` clauses with different ranges in MV and query
• links to: GitHub Pull Request #1002