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

Support STRING_AGG in BeamSQL

    XMLWordPrintableJSON

    Details

      Description

      Support STRING_AGG function in ZetaSQL dialect. (Also if Calcite has this function built-in, support it in Calcite dialect too)

      See the reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#string_agg

      Examples:

      SELECT STRING_AGG(fruit) AS string_agg
      FROM UNNEST(["apple", NULL, "pear", "banana", "pear"]) AS fruit;
      
      +------------------------+
      | string_agg             |
      +------------------------+
      | apple,pear,banana,pear |
      +------------------------+
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                QZMark Qihang Zeng
                Reporter:
                amaliujia Rui Wang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: