[SPARK-13221] GroupingSets Returns an Incorrect Results

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.6.0, 2.0.0
• Fix Version/s: 2.0.0
• Component/s: SQL
• Labels: correctness
• Assignee: Xiao Li
• Reporter: Xiao Li
• Created: 06/Feb/16 01:54
• Updated: 31/Aug/16 21:29
• Resolved: 16/Feb/16 07:44

Description

The following query returns a wrong result:

sql("select course, sum(earnings) as sum from courseSales group by course, earnings" +
     " grouping sets((), (course), (course, earnings))" +
     " order by course, sum").show()

Before the fix, the results are like

[null,null]
[Java,null]
[Java,20000.0]
[Java,30000.0]
[dotNET,null]
[dotNET,5000.0]
[dotNET,10000.0]
[dotNET,48000.0]

After the fix, the results are corrected:

[null,113000.0]
[Java,20000.0]
[Java,30000.0]
[Java,50000.0]
[dotNET,5000.0]
[dotNET,10000.0]
[dotNET,48000.0]
[dotNET,63000.0]

Issue Links

• blocks: SPARK-12720 SQL generation support for cube, rollup, and grouping set
• links to: [Github] Pull Request #11100 (gatorsmile)