hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-3185) allow union set operation without ALL keyword (align to ISO-SQL 2011 specification)
Date Sun, 06 Oct 2013 17:43:44 GMT

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

Mime
View raw message