[BEAM-4476] Syntax Features Unsupported

• Type: Task
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: dsl-sql
• Assignee: Unassigned
• Reporter: Kai Jiang
• Created: 05/Jun/18 06:17
• Updated: 03/Jun/22 21:15

Description

Based on current version (56dc4cf), a coverage test was done with TPC-DS queries and TPC-H queries. All the tests were running on DirectRunner. We noticed that there are some features Beam SQL is now not supported.  

This issue is used for an umbrella ticket to keep track of features we need to implement and support.

Issue Links

• contains: BEAM-5111 SUM0/SUM
• contains: BEAM-4385 Support LIKE operator
• contains: BEAM-4388 Support optimized logical plan
• contains: BEAM-5064 Support ORDER BY in Global window
• relates to: BEAM-5046 Implement Missing Standard SQL functions in BeamSQL
• links to: refactoring literal expression type conversion
• links to: Result Spreadsheet for TPC queries pass

Sub-Tasks

• Support EXISTS operator: Resolved
• CASE expression output type mismatch: Resolved
• Implement sum0 aggregation function: Resolved
• Implement Date Comparison in BeamSqlCompareExpression: Resolved
• Implement Cost calculations for Cost-Based Optimization (CBO): Resolved