hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sanjiv singh (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-10782) Support EXCEPT set operation
Date Thu, 21 May 2015 09:01:01 GMT

     [ 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)

Mime
View raw message