[ https://issues.apache.org/jira/browse/HIVE-22259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez reassigned HIVE-22259: ---------------------------------------------- Assignee: Jesus Camacho Rodriguez > Rewriting fails for `BETWEEN` clauses with different ranges in MV and query > --------------------------------------------------------------------------- > > Key: HIVE-22259 > URL: https://issues.apache.org/jira/browse/HIVE-22259 > Project: Hive > Issue Type: Sub-task > Components: CBO, Materialized views > Reporter: Steve Carlin > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: expr5.sql > > > 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; -- This message was sent by Atlassian Jira (v8.3.4#803005)