spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Somasundaram Sekar <>
Subject Equivalent of Redshift ListAgg function in Spark (Pyspak)
Date Sun, 08 Oct 2017 11:59:42 GMT

I want to concat multiple columns into a single column after grouping the

I want an functional equivalent of Redshift ListAgg function

pg_catalog.Listagg(column, '|')

         within GROUP( ORDER BY column) AS


LISTAGG Function

: For each group in a query, the LISTAGG aggregate function orders the rows
for that group according to the ORDER BY expression, then concatenates the
values into a single string.

View raw message