[ 
https://issues.apache.org/jira/browse/SPARK-10601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14987666#comment-14987666
 ] 

Rick Hillegas commented on SPARK-10601:
---------------------------------------

This is a useful operator supported by Oracle: 
http://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm. However, 
the MINUS operator is not part of the ANSI/ISO SQL Standard. The Standard 
workaround is to LEFT JOIN the first set with the second set and add a WHERE 
clause which discards the rows whose right half is filled with NULLs.

> Spark SQL - Support for MINUS
> -----------------------------
>
>                 Key: SPARK-10601
>                 URL: https://issues.apache.org/jira/browse/SPARK-10601
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Richard Garris
>
> Spark SQL does not current supported SQL Minus



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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

Reply via email to