sanjiv singh created HIVE-10782:
-----------------------------------
Summary: Support EXCEPT set operation
Key: HIVE-10782
URL: https://issues.apache.org/jira/browse/HIVE-10782
Project: Hive
Issue Type: Improvement
Components: SQL
Reporter: sanjiv singh
Support a EXCEPT operation as <qb1> EXCEPT <qb2> .
Common requirement of queries to project two sets where you want result set
which contains distinct rows from the left input query that aren’t output by
the right input query.
The following sample statement combines the results with the INTERSECT
operator, which returns distinct rows from the left input query that aren’t
output by the right input query:
SELECT * FROM tableA
EXCEPT
SELECT * FROM tableB;
current exception:
FAILED: ParseException line *:** missing EOF at 'SELECT' near 'EXCEPT'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
