[HIVE-9132] CBO: Calcite Operator To Hive Operator (Calcite Return Path)

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: CBO
• Assignee: Unassigned
• Reporter: Laljo John Pullokkaran
• Created: 16/Dec/14 23:44
• Updated: 23/Jun/21 19:43

Description

This is the umbrella issue that captures conversion of Calcite Operator Tree to Hive Operator Tree.

Issue Links

• is related to: HIVE-5775 Introduce Cost Based Optimizer to Hive
• is related to: HIVE-10328 Enable new return path for cbo
• relates to: HIVE-5775 Introduce Cost Based Optimizer to Hive
• relates to: HIVE-12899 Bring query optimization time down
• relates to: HIVE-11918 Implement/Enable constant related optimization rules in Calcite

Sub-Tasks

• CBO (Calcite Return Path): Equi join followed by theta join produces a cross product: Open
• CBO : Calculate join selectivity when computing HiveJoin cost: Open
• CBO (Calcite Return Path): groupby_grouping_id2.q returns wrong results: Open
• CBO: Calcite Operator To Hive Operator (Calcite Return Path): MiniTezCliDriver vector_auto_smb_mapjoin_14.q failure: Patch Available
• CBO: Calcite Operator To Hive Operator (Calcite Return Path): TestCliDriver groupby_grouping_sets4.q failure: Patch Available
• CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix wrong result in join_filters_overlap: Open
• CBO: Calcite Operator To Hive Operator(Calcite Return Path): Support Tablesample clause: Open
• Create view doesn't work with Calcite Return path: Open
• Join fails on operator return path on CBO: Open
• Improve return path enabling/disabling: Patch Available