[HIVE-26618] Add setting to turn on/off removing sections of a query plan known never produces rows

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Component/s: CBO
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 11/Oct/22 08:48
• Updated: 22/Nov/23 11:37
• Resolved: 22/Nov/23 11:37

Description

HIVE-26524 introduced an optimization to remove sections of query plan known never produces rows.

Add a setting into hive conf to turn on/off this optimization.

When the optimization is turned off restore the legacy behavior:

• represent empty result operator with HiveSortLimit 0
• disable HiveRemoveEmptySingleRules

Issue Links

• relates to: HIVE-26524 Use Calcite to remove sections of a query plan known never produces rows
• links to: GitHub Pull Request #3659