[IMPALA-12871] Implement front end using Calcite

• Type: Epic
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: Frontend
• Epic Name: Implement front end using Calcite
• Epic Color: ghx-label-5
• Assignee: Steve Carlin
• Reporter: Steve Carlin
• Created: 05/Mar/24 14:45
• Updated: 16/Jul/24 23:40

Description

Calcite provides a framework for compilation that will allow us to provide optimizations more easily and also allow more support for SQL standard queries.  This Epic will track the multiple commits needed to support this

Sub-Tasks

• Create query option to choose the planner type: Open
• Implement Values and Union Calcite RelNodes: Open
• Implement Sort capability: Open
• Calcite planner: Invert Joins should be implemented as a rule: Open
• Calcite planner: Need to code Parquet Count Star Optimization: Open
• Use a Map instead of an ArrayList for Expr in HDFS RelNode: Open
• Implement aggregation capability: Open
• Need to make a more generic parser for evaluating stmts for the Calcite Planner: Open
• Need to remove awkward Authorization instantiation.: Open
• Need infrastructure to handle implicit casting for functions: Open
• Handle UDFs in Calcite planner: Open
• Cleanup Parser.jj for Calcite planner to only use supported syntax: Open
• Better exception for Analyze*Expr class in Calcite Planner: Open
• computeEvalCost needs better implementation in Calcite planner: Open
• ImpalaOperator getAllowedSignatures needs to be implemented: Open
• (Calcite) Implement tryConvertToTopN as a rule: Open
• Support Impala Join HInts: Open
• Implement analytic functions: Open
• Calcite: fix and enable tpcds and tpch tests: Open
• Handle the Sarg function in the Calcite planner: Open