[jira] [Updated] (SPARK-13221) GroupingSets Returns an Incorrect Results
[ https://issues.apache.org/jira/browse/SPARK-13221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Rosen updated SPARK-13221: --- Labels: correctness (was: ) > GroupingSets Returns an Incorrect Results > - > > Key: SPARK-13221 > URL: https://issues.apache.org/jira/browse/SPARK-13221 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.0, 2.0.0 >Reporter: Xiao Li >Assignee: Xiao Li >Priority: Critical > Labels: correctness > Fix For: 2.0.0 > > > The following query returns a wrong result: > {code} > sql("select course, sum(earnings) as sum from courseSales group by course, > earnings" + > " grouping sets((), (course), (course, earnings))" + > " order by course, sum").show() > {code} > Before the fix, the results are like > {code} > [null,null] > [Java,null] > [Java,2.0] > [Java,3.0] > [dotNET,null] > [dotNET,5000.0] > [dotNET,1.0] > [dotNET,48000.0] > {code} > After the fix, the results are corrected: > {code} > [null,113000.0] > [Java,2.0] > [Java,3.0] > [Java,5.0] > [dotNET,5000.0] > [dotNET,1.0] > [dotNET,48000.0] > [dotNET,63000.0] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Updated] (SPARK-13221) GroupingSets Returns an Incorrect Results
[ https://issues.apache.org/jira/browse/SPARK-13221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Owen updated SPARK-13221: -- Assignee: Xiao Li > GroupingSets Returns an Incorrect Results > - > > Key: SPARK-13221 > URL: https://issues.apache.org/jira/browse/SPARK-13221 > Project: Spark > Issue Type: Bug > Components: SQL >Affects Versions: 1.6.0, 2.0.0 >Reporter: Xiao Li >Assignee: Xiao Li >Priority: Critical > Fix For: 2.0.0 > > > The following query returns a wrong result: > {code} > sql("select course, sum(earnings) as sum from courseSales group by course, > earnings" + > " grouping sets((), (course), (course, earnings))" + > " order by course, sum").show() > {code} > Before the fix, the results are like > {code} > [null,null] > [Java,null] > [Java,2.0] > [Java,3.0] > [dotNET,null] > [dotNET,5000.0] > [dotNET,1.0] > [dotNET,48000.0] > {code} > After the fix, the results are corrected: > {code} > [null,113000.0] > [Java,2.0] > [Java,3.0] > [Java,5.0] > [dotNET,5000.0] > [dotNET,1.0] > [dotNET,48000.0] > [dotNET,63000.0] > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org