Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-11388

Implement missing ZETA_SQL Functions

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: dsl-sql-zetasql
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                shehzaadn Shehzaad Nakhoda
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h 40m
                  4h 40m