Henry Robinson created SPARK-23062:
--------------------------------------

             Summary: EXCEPT documentation should make it clear that it's 
EXCEPT DISTINCT
                 Key: SPARK-23062
                 URL: https://issues.apache.org/jira/browse/SPARK-23062
             Project: Spark
          Issue Type: Improvement
          Components: Documentation, SQL
    Affects Versions: 2.0.0
            Reporter: Henry Robinson
            Priority: Trivial


Between 1.6 and 2.0, the default behaviour for {{EXCEPT}} changed from {{EXCEPT 
ALL}} to {{EXCEPT DISTINCT}}. This is reasonable: postgres defaults to the 
same, and if you try and explicitly use {{EXCEPT ALL}} in 2.0 you get a good 
error message. However, the change was confusing to some users, so it's worth 
being explicit in the documentation.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to