[HIVE-11918] Implement/Enable constant related optimization rules in Calcite

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 22/Sep/15 20:18
• Updated: 19/Jul/16 00:23
• Resolved: 19/Jul/16 00:23

Description

Right now, Hive optimizer (Calcite) is short of the constant related optimization rules. For example, constant folding, constant propagation and constant transitive rules. Although Hive later provides those rules in the logical optimizer, we would like to implement those inside Calcite. This will benefit the current optimization as well as the optimization based on return path that we are planning to use in the future. This JIRA is the umbrella JIRA to implement/enable those rules.

Issue Links

• duplicates: HIVE-13608 We should provide better error message while constraints with duplicate names are created
• is related to: CALCITE-902 Match nullability when reducing expressions in a Project
• is related to: CALCITE-909 Make ReduceExpressionsRule extensible
• is related to: HIVE-11110 Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation
• is related to: HIVE-9132 CBO: Calcite Operator To Hive Operator (Calcite Return Path)