[
https://issues.apache.org/jira/browse/HIVE-10782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Miklos Szurap resolved HIVE-10782.
----------------------------------
Fix Version/s: 2.3.0
Resolution: Fixed
Closing this as it has been fixed in HIVE-12764.
> 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
> Priority: Major
> Fix For: 2.3.0
>
>
> 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 EXCEPT 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
(v8.20.10#820010)
