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)
