[ https://issues.apache.org/jira/browse/SPARK-42746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot reassigned SPARK-42746: -------------------------------------- Assignee: Apache Spark > Add the LISTAGG() aggregate function > ------------------------------------ > > Key: SPARK-42746 > URL: https://issues.apache.org/jira/browse/SPARK-42746 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.4.0 > Reporter: Max Gekk > Assignee: Apache Spark > Priority: Major > Labels: pull-request-available > > {{listagg()}} is a common and useful aggregation function to concatenate > string values in a column, optionally by a certain order. The systems below > have supported such function already: > * Oracle: > [https://docs.oracle.com/cd/E11882_01/server.112/e41084/functions089.htm#SQLRF30030] > * Snowflake: [https://docs.snowflake.com/en/sql-reference/functions/listagg] > * Amazon Redshift: > [https://docs.aws.amazon.com/redshift/latest/dg/r_LISTAGG.html] > * Google BigQuery: > [https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#string_agg] > Need to introduce this new aggregate in Spark, both as a regular aggregate > and as a window function. > Proposed syntax: > {code:sql} > LISTAGG( [ DISTINCT ] <expr> [, <delimiter> ] ) [ WITHIN GROUP ( > <orderby_clause> ) ] > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org