[HIVE-22257] Commutativity of operations is not taken into account, e.g., '+'

• 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
• Assignee: Vineet Garg
• Reporter: Steve Carlin
• Created: 27/Sep/19 20:51
• Updated: 27/Feb/24 22:23
• Resolved: 09/Sep/20 21:14

Description

...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;

Issue Links

• is caused by: CALCITE-3914 Improve SubstitutionVisitor to consider RexCall of type PLUS and TIMES for canonicalization
• Is contained by: HIVE-23456 Upgrade Calcite version to 1.25.0