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)