Steve Carlin created HIVE-22256: ----------------------------------- Summary: Rewriting fails when `IN` clause has items in different order in MV and query. Key: HIVE-22256 URL: https://issues.apache.org/jira/browse/HIVE-22256 Project: Hive Issue Type: Sub-task Components: CBO Affects Versions: 3.1.2 Reporter: Steve Carlin Attachments: expr2.sql
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); -- This message was sent by Atlassian Jira (v8.3.4#803005)