[CALCITE-2736] ReduceExpressionsRule never reduces dynamic expressions but this should be configurable

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.28.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jacques Nadeau
• Reporter: Jacques Nadeau
• Created: 12/Dec/18 03:40
• Updated: 25/Apr/23 09:35
• Resolved: 13/Oct/21 23:23

Description

There are situations where it is helpful to reduce dynamic SqlCalls. Right now, the ReduceExpressionsRule always avoids doing this. We should enhance the rule so this can be configurable depending on where in planning the rule is used.

Issue Links

• is related to: HIVE-27291 Constant reduction in CBO does not work for UNIX_TIMESTAMP
• relates to: CALCITE-2823 Prevent optimization of non-deterministic functions
• links to: GitHub Pull Request #980
• links to: GitHub Pull Request #2502