You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "sanjiv singh (JIRA)" <ji...@apache.org> on 2015/05/21 09:30:00 UTC

[jira] [Created] (HIVE-10783) Support MINUS set operation

sanjiv singh created HIVE-10783:
-----------------------------------

             Summary: Support MINUS set operation 
                 Key: HIVE-10783
                 URL: https://issues.apache.org/jira/browse/HIVE-10783
             Project: Hive
          Issue Type: Improvement
          Components: SQL
            Reporter: sanjiv singh


Support a MINUS operation  as <qb1> MINUS <qb2> .


Common requirement of queries to project two sets where you want result set which contains only unique rows returned by the first query but not by the second.


The following sample statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second:

SELECT * FROM tableA
MINUS
SELECT * FROM tableB;

current exception:
FAILED: ParseException line *:** missing EOF at 'SELECT' near 'MINUS'



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