[ https://issues.apache.org/jira/browse/SPARK-27878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17003836#comment-17003836 ]
Hyukjin Kwon commented on SPARK-27878: -------------------------------------- Ah, [~maropu] sorry I missed your comment. Feel free to reopen if you still think it looks worthwhile. > Support ARRAY(sub-SELECT) expressions > ------------------------------------- > > Key: SPARK-27878 > URL: https://issues.apache.org/jira/browse/SPARK-27878 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Priority: Major > > Construct an array from the results of a subquery. In this form, the array > constructor is written with the key word {{ARRAY}} followed by a > parenthesized (not bracketed) subquery. For example: > {code:sql} > SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%'); > array > ----------------------------------------------------------------------- > {2011,1954,1948,1952,1951,1244,1950,2005,1949,1953,2006,31,2412,2413} > (1 row) > {code} > More details: > > [https://www.postgresql.org/docs/9.3/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS] > [https://github.com/postgres/postgres/commit/730840c9b649a48604083270d48792915ca89233] -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org