Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5545

Add LISTAGG() fuction

    XMLWordPrintableJSON

    Details

    • Epic Color:
      ghx-label-4

      Description

      SQL:2016 added LISTAGG() as a standard function for aggregating records into a string list. This would introduce a superset of functionality that GROUP_CONCAT() implements today.

      <listagg set function> ::=
        LISTAGG <left paren> [ <set quantifier> ] <character value expression>
            <comma> <listagg separator> [ <listagg overflow clause> ] <right paren>
            <within group specification>
      <listagg separator> ::=
        <character string literal>
      <listagg overflow clause> ::=
        ON OVERFLOW <overflow behavior>
      <overflow behavior> ::=
          ERROR
        | TRUNCATE [ <listagg truncation filler> ] <listagg count indication>
      <listagg truncation filler> ::=
        <character string literal>
      <listagg count indication> ::=
          WITH COUNT>
        | WITHOUT COUNT>
      <array aggregate function> ::=
        ARRAY_AGG
      <left paren> <value expression> [ ORDER BY <sort specification list> ] <right paren>
      <row pattern count function> ::=
        COUNT <left paren> <row pattern variable name> <period> <asterisk> <right paren>
      

      References:

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jinchul Jin Chul Kim
                Reporter:
                grahn Greg Rahn
              • Votes:
                4 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: