You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2012/06/24 14:24:42 UTC
[jira] [Created] (HIVE-3185) allow union set operation without ALL
keyword (align to ISO-SQL 2012 specification)
N Campbell created HIVE-3185:
--------------------------------
Summary: 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
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
[jira] [Updated] (HIVE-3185) allow union set operation without ALL
keyword (align to ISO-SQL 2012 specification)
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ 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