korowa commented on code in PR #7385: URL: https://github.com/apache/arrow-datafusion/pull/7385#discussion_r1303912892
########## datafusion/sqllogictest/test_files/aggregate.slt: ########## @@ -1280,6 +1280,10 @@ NULL NULL 781 7.81 125 -117 100 # ---- # [4, 2, 3, 5, 1] +# additional count(1) forces array_agg_distinct instead of array_agg over aggregated by c2 data +statement ok +SELECT array_agg(distinct c2), count(1) FROM aggregate_test_100 Review Comment: Not sure if there exists SQL-level `unnest `🤔 -- it seems to be provided only by dataframe API (also [PR](https://github.com/apache/arrow-datafusion/pull/6796) and [issue](https://github.com/apache/arrow-datafusion/issues/6555) for this still are open). But yeah, I can manually unnest in anyway, thank you! -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
