[
https://issues.apache.org/jira/browse/IMPALA-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Quanlong Huang reassigned IMPALA-5545:
--------------------------------------
Assignee: (was: Alex Sun)
Make this unassigned so other guys can pick it. Feel free to pick it again if
you are still working on this, [~sneakyburro] .
> Add LISTAGG() fuction
> ---------------------
>
> Key: IMPALA-5545
> URL: https://issues.apache.org/jira/browse/IMPALA-5545
> Project: IMPALA
> Issue Type: New Feature
> Components: Backend, Frontend
> Reporter: Greg Rahn
> Priority: Major
> Labels: ansi-sql, ramp-up, sql-language
>
> 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.
> {noformat}
> <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>
> {noformat}
> References:
> - http://modern-sql.com/feature/listagg
> - http://docs.oracle.com/database/122/SQLRF/LISTAGG.htm
> - https://oracle-base.com/articles/12c/listagg-function-enhancements-12cr2
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
