[SPARK-25505] The output order of grouping columns in Pivot is different from the input order

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 2.4.0
• Component/s: SQL
• Assignee: Wei Xue
• Reporter: Wei Xue
• Created: 21/Sep/18 14:27
• Updated: 28/Sep/18 11:00
• Resolved: 28/Sep/18 07:10

Description

For example,

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)
  FOR course IN ('dotNET', 'Java')
)

The output columns should be "a, z, b, y, c, x, d, w, ..." but now it is "a, b, c, d, w, x, y, z, ..."

Issue Links

• links to: [Github] Pull Request #22519 (maryannxue)
• links to: [Github] Pull Request #22519 (maryannxue)
• links to: [Github] Pull Request #22582 (mgaido91)