hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sanjiv singh (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-10783) Support MINUS set operation
Date Thu, 21 May 2015 07:30:00 GMT
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)

Mime
View raw message