[ https://issues.apache.org/jira/browse/SPARK-24163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li reopened SPARK-24163: ----------------------------- > Support "ANY" or sub-query for Pivot "IN" clause > ------------------------------------------------ > > Key: SPARK-24163 > URL: https://issues.apache.org/jira/browse/SPARK-24163 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 2.3.0 > Reporter: Wei Xue > Priority: Major > Labels: bulk-closed > > This is part of a functionality extension to Pivot SQL support as SPARK-24035. > Currently, only literal values are allowed in Pivot "IN" clause. To support > ANY or a sub-query in the "IN" clause (the examples of which provided below), > we need to enable evaluation of a sub-query before/during query analysis time. > {code:java} > SELECT * FROM ( > SELECT year, course, earnings FROM courseSales > ) > PIVOT ( > sum(earnings) > FOR course IN ANY > );{code} > {code:java} > SELECT * FROM ( > SELECT year, course, earnings FROM courseSales > ) > PIVOT ( > sum(earnings) > FOR course IN ( > SELECT course FROM courses > WHERE region = 'AZ' > ) > ); > {code} -- 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