Filip Davidovic created SPARK-55356:
---------------------------------------
Summary: Support alias in Spark SQL PIVOT
Key: SPARK-55356
URL: https://issues.apache.org/jira/browse/SPARK-55356
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 4.1.1
Reporter: Filip Davidovic
As title suggests, add support for alias on the PIVOT clause.
{quote}Extend the {{PIVOT}} clause to accept an optional alias ({{{}PIVOT (...)
AS alias{}}}), allowing the pivoted result set to be referenced by name in the
surrounding query context. The alias qualifies all columns produced by the
pivot operation, including both the grouping columns and the dynamically
generated value columns. When an alias is provided, columns may be referenced
as {{{}alias.column_name{}}}. When omitted, current unqualified resolution
behaviour is preserved. In queries with multiple pivots or joins, the alias
disambiguates column references. The alias scope is limited to the query block
in which the pivot appears.
{quote}
Main reason for the improvement is parity with platforms like SQL Server and
Snowflake. When customers want to migrate, their queries using PIVOT alias
can't be automatically transpiled, requiring a human in the loop.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
