[jira] [Resolved] (HIVE-3185) allow union set operation without ALL keyword (align to ISO-SQL 2011 specification)

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

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