[
https://issues.apache.org/jira/browse/HIVE-3185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan resolved HIVE-3185.
------------------------------------
Resolution: Duplicate
Fix Version/s: 1.2.0
Assignee: Pengcheng Xiong
> 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
> Assignee: Pengcheng Xiong
> Fix For: 1.2.0
>
>
> 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.3.4#6332)
