hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-3185) allow union set operation without ALL keyword (align to ISO-SQL 2011 specification)
Date Mon, 09 Feb 2015 18:14:35 GMT

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

Mime
View raw message