You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2018/05/02 23:50:00 UTC
[jira] [Created] (SPARK-24163) Support "ANY" or sub-query for Pivot
"IN" clause
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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org