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

["N Campbell (JIRA)" <ji...@apache.org>]

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