[ https://issues.apache.org/jira/browse/SPARK-14967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan resolved SPARK-14967. --------------------------------- Resolution: Fixed Fix Version/s: 2.0.0 Issue resolved by pull request 12736 [https://github.com/apache/spark/pull/12736] > EXCEPT does not follow SQL compliance > ------------------------------------- > > Key: SPARK-14967 > URL: https://issues.apache.org/jira/browse/SPARK-14967 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.0.0 > Reporter: Xiao Li > Fix For: 2.0.0 > > > {noformat} > test("except") { > val df_left = Seq(1, 2, 2, 3, 3, 4).toDF("id") > val df_right = Seq(1, 3).toDF("id") > checkAnswer( > df_left.except(df_right), > Row(2) :: Row(2) :: Row(4) :: Nil > ) > } > {noformat} > This is the example. > For `EXCEPT ALL`, we should output > {noformat} > Row(2) :: Row(2) :: Row(3) :: Row(4) :: Nil > {noformat} > For `EXCEPT DISTINCT`, we should output > {noformat} > Row(2) :: Row(4) :: Nil > {noformat} > Thus, the current master is wrong. The result it generates is > {noformat} > Row(2) :: Row(2) :: Row(4) :: Nil > {noformat} -- 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