maropu commented on a change in pull request #27058: [SPARK-30276][SQL] Support Filter expression allows simultaneous use of DISTINCT URL: https://github.com/apache/spark/pull/27058#discussion_r367727323
########## File path: sql/core/src/test/resources/sql-tests/results/postgreSQL/groupingsets.sql.out ########## @@ -444,10 +444,29 @@ NULL 1 -- !query 34 -select count(*) from gstest4 group by rollup(unhashable_col,unsortable_col) +select ten, sum(distinct four) filter (where string(four) like '123') from onek a +group by rollup(ten) -- !query 34 schema -struct<count(1):bigint> +struct<ten:int,sum(DISTINCT four) FILTER (WHERE CAST(four AS STRING) LIKE 123):bigint> -- !query 34 output Review comment: Checked, too: https://github.com/postgres/postgres/blob/0fca3d0a4ec297bff5a5cb01dfe345e0f63d7d63/src/test/regress/expected/groupingsets.out#L822 ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
