Maryann Xue created SPARK-24162:
-----------------------------------
Summary: Support aliased literal values for Pivot "IN" clause
Key: SPARK-24162
URL: https://issues.apache.org/jira/browse/SPARK-24162
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.
When literal values are specified in Pivot IN clause, it would be nice to allow
aliases for those values so that the output column names can be customized. For
example:
{code:java}
SELECT * FROM (
SELECT year, course, earnings FROM courseSales
)
PIVOT (
sum(earnings)
FOR course IN ('dotNET' as c1, 'Java' as c2)
);{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
