[HIVE-12393] Simplify ColumnPruner when CBO optimizes the query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.0.0
• Component/s: Logical Optimizer
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 12/Nov/15 16:43
• Updated: 27/Feb/24 22:24
• Resolved: 08/Jul/16 20:21

Description

The plan for any given query optimized by CBO will always contain a Project operator on top of the TS that prunes that columns that are not needed.

Thus, there is no need for Hive optimizer to traverse the whole plan to check which columns can be pruned. In fact, Hive ColumnPruner optimizer only needs to match TS operators when CBO optimized the plan.

Issue Links

• duplicates: HIVE-12900 Disable Hive ColumnPruner optimizer when CBO has optimized the plan