[BEAM-11388] Implement missing ZETA_SQL Functions

• Type: Improvement
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: dsl-sql-zetasql
• Assignee: Unassigned
• Reporter: Shehzaad Nakhoda
• Created: 03/Dec/20 09:54
• Updated: 04/Jun/22 18:15

Description

Implement the following functions for Beam SQL ZetaSQL dialect, as CombineFn. (Example implementation for BIT_OR.) (Java SQL only.)
Their output in Beam should match BigQuery.
Write compliance tests for each function.
List:
ANY_VALUE
ARRAY_AGG
ARRAY_CONCAT_AGG
BIT_AND
BIT_XOR
COUNT
COUNTIF
LOGICAL_AND
LOGICAL_OR
STRING_AGG
CORR
COVAR_POP
COVAR_SAMP
STDDEV_POP
STDDEV_SAMP
STDDEV
VAR_POP
VAR_SAMP
VARIANCE
APPROX_COUNT_DISTINCT
APPROX_QUANTILES
APPROX_TOP_COUNT
APPROX_TOP_SUM

Issue Links

• is a parent of: BEAM-11809 Support COVAR_SAMP function in Beam ZetaSQL
• is a parent of: BEAM-11743 Implement COUNTIF Aggregation function for Zetasql
• is a parent of: BEAM-10809 Implement STDDEV, STDDEV_POP, STDDEV_SAMP for Beam SQL ZetaSQL dialect as CombineFn

Sub-Tasks

• Implement the LOGICAL_AND function for Beam SQL ZetaSQL dialect, as CombineFn.: Open
• Implement the LOGICAL_OR function for Beam SQL ZetaSQL dialect, as CombineFn.: Open