[
https://issues.apache.org/jira/browse/HIVE-10782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
sanjiv singh updated HIVE-10782:
--------------------------------
Description:
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'
was:
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'
> 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 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
(v6.3.4#6332)
