Github user dongjoon-hyun commented on a diff in the pull request:
https://github.com/apache/spark/pull/22582#discussion_r221409258
--- Diff: sql/core/src/test/resources/sql-tests/inputs/pivot.sql ---
@@ -297,3 +297,13 @@ PIVOT (
sum(earnings)
FOR course IN ('dotNET', 'Java')
);
+
+-- correctly handle pivot columns with different cases
+SELECT * FROM (
+ SELECT course, earnings, "a" as a, "z" as z, "b" as b, "y" as y, "c" as
c, "x" as x, "d" as d, "w" as w
+ FROM courseSales
+)
+PIVOT (
+ sum(Earnings)
--- End diff --
You can update the comment at line 291, too.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
