You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2012/06/25 05:52:43 UTC
[jira] [Updated] (HIVE-3185) allow union set operation without ALL
keyword (align to ISO-SQL 2012 specification)
[ https://issues.apache.org/jira/browse/HIVE-3185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3185:
---------------------------------
Component/s: SQL
> allow union set operation without ALL keyword (align to ISO-SQL 2012 specification)
> -----------------------------------------------------------------------------------
>
> Key: HIVE-3185
> URL: https://issues.apache.org/jira/browse/HIVE-3185
> Project: Hive
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 0.8.0
> Reporter: N Campbell
>
> Allow a union operation to be specified as <qb1> union <qb2> in addition to th <qb1> union all <qb2>
> Common requirement of queries to project two sets where it is not always the case you want distinct rows in the set. Failing to do so obviously will result in the current exception:
> mismatched input 'select' expecting ALL near 'union' in query operator
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira