[HIVE-25880] Add configuration option to exclude rules by a regex on their description

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Alessandro Solimando
• Reporter: Alessandro Solimando
• Created: 19/Jan/22 18:10
• Updated: 17/Nov/22 08:48
• Resolved: 20/Jan/22 19:55

Description

Introduce a configuration option to exclude rules via a regex on the rule description, based on Calcite's org.apache.calcite.plan.AbstractRelOptPlanner#setRuleDescExclusionFilter.

The motivation is to provide a quick workaround when one or more rules are causing issues at planning time, without code changes.

Another use would be to quickly experiment on the impact of disabling one or more rules on the compute plan.

An example of configuration would be as follows:

set hive.cbo.rule.exclusion.regex=HiveJoinPushTransitivePredicatesRule|HivePreFilteringRule;

The above configuration setting would exclude from planning both HiveJoinPushTransitivePredicatesRule and HivePreFilteringRule rules.

Issue Links

• is depended upon by: HIVE-25938 Print excluded rules from CBO
• links to: GitHub Pull Request #2955