Helios He created SPARK-55501:
---------------------------------
Summary: Listagg aggregate function: DISTINCT + WITHIN GROUP ORDER
BY not working together for non-string/binary columns
Key: SPARK-55501
URL: https://issues.apache.org/jira/browse/SPARK-55501
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 4.0.0
Reporter: Helios He
minimal reproducible example:
{code:java}
SELECT listagg(distinct col) within group (order by col)
FROM VALUES (1), (2), (2), (3) t(col){code}
this query fails but should work.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
