[
https://issues.apache.org/jira/browse/HIVE-3185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated HIVE-3185:
-----------------------------
Summary: allow union set operation without ALL keyword (align to ISO-SQL
2011 specification) (was: allow union set operation without ALL keyword (align
to ISO-SQL 2012 specification))
> allow union set operation without ALL keyword (align to ISO-SQL 2011
> 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 was sent by Atlassian JIRA
(v6.1#6144)
