Details
-
New Feature
-
Status: In Progress
-
Major
-
Resolution: Unresolved
-
None
-
None
-
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
- relates to
-
IMPALA-5083 add ORDER BY clause to GROUP_CONCAT()
- Resolved