Github user gatorsmile commented on a diff in the pull request:

    https://github.com/apache/spark/pull/19451#discussion_r147477134
  
    --- Diff: sql/core/src/test/resources/sql-tests/inputs/except.sql ---
    @@ -0,0 +1,57 @@
    +-- Tests different scenarios of except operation
    +create temporary view t1 as select * from values
    +  ("one", 1),
    +  ("two", 2),
    +  ("three", 3),
    +  ("one", NULL)
    +  as t1(k, v);
    +
    +create temporary view t2 as select * from values
    +  ("one", 1),
    +  ("two", 22),
    +  ("one", 5),
    +  ("one", NULL),
    +  (NULL, 5)
    +  as t2(k, v);
    +
    +
    +-- Except operation that will be replaced by left anti join
    +SELECT * FROM t1 EXCEPT SELECT * FROM t2;
    --- End diff --
    
    How about the result?


---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to