[jira] [Updated] (HIVE-22257) Commutativity of operations is not taken into account, e.g., '+'
[ https://issues.apache.org/jira/browse/HIVE-22257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated HIVE-22257: --- Component/s: Materialized views > Commutativity of operations is not taken into account, e.g., '+' > > > Key: HIVE-22257 > URL: https://issues.apache.org/jira/browse/HIVE-22257 > Project: Hive > Issue Type: Sub-task > Components: CBO, Materialized views >Affects Versions: 3.1.2 >Reporter: Steve Carlin >Priority: Major > Attachments: expr9.sql > > > ...as stated in subject. Script to reproduce is attached. > Query and materialized view are as follows: > create materialized view view5 stored as orc as (select prod_id, cust_id, > store_id, sale_date, qty, amt, descr from sales where cust_id + prod_id > 1 + > 2); > explain extended select prod_id, cust_id from sales where prod_id + cust_id > > 1 + 2; -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22257) Commutativity of operations is not taken into account, e.g., '+'
[ https://issues.apache.org/jira/browse/HIVE-22257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steve Carlin updated HIVE-22257: Attachment: expr9.sql > Commutativity of operations is not taken into account, e.g., '+' > > > Key: HIVE-22257 > URL: https://issues.apache.org/jira/browse/HIVE-22257 > Project: Hive > Issue Type: Sub-task > Components: CBO >Affects Versions: 3.1.2 >Reporter: Steve Carlin >Priority: Major > Attachments: expr9.sql > > > ...as stated in subject. Script to reproduce is attached. > Query and materialized view are as follows: > create materialized view view5 stored as orc as (select prod_id, cust_id, > store_id, sale_date, qty, amt, descr from sales where cust_id + prod_id > 1 + > 2); > explain extended select prod_id, cust_id from sales where prod_id + cust_id > > 1 + 2; -- This message was sent by Atlassian Jira (v8.3.4#803005)