Maryann Xue created SPARK-24163:
-----------------------------------
Summary: 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: Maryann Xue
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
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
