[BEAM-11808] ZetaSQL layer doesn't support aggregate functions with two arguments

• Type: Improvement
• Status: Resolved
• Priority: P3
• Resolution: Fixed
• Fix Version/s: 2.37.0
• Component/s: dsl-sql-zetasql
• Assignee: Benjamin Gonzalez
• Reporter: Sonam Ramchand
• Created: 12/Feb/21 08:54
• Updated: 18/Jan/22 21:49
• Resolved: 18/Jan/22 21:41

Description

Blocked by:  parsed ZetaSQL to a Calcite logical expression doesn't currently support aggregate functions with multiple columns. https://github.com/apache/beam/blob/3bb232fb098700de408f574585dfe74bbaff7230/sdks/java/extensions/sql/zetasql/src/main/java/org/apache/beam/sdk/extensions/sql/zetasql/translation/AggregateScanConverter.java#L147

Issue Links

• blocks: BEAM-11798 Support COVAR_POP function in Beam ZetaSQL
• blocks: BEAM-11809 Support COVAR_SAMP function in Beam ZetaSQL
• blocks: BEAM-9879 Support STRING_AGG in BeamSQL
• links to: GitHub Pull Request #16200