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] [Created] (HIVE-3185) allow union set operation without ALL keyword (align to ISO-SQL 2012 specification)
Date Sun, 24 Jun 2012 12:24:42 GMT
N Campbell created HIVE-3185:
--------------------------------

             Summary: allow union set operation without ALL keyword (align to ISO-SQL 2012
specification)
                 Key: HIVE-3185
                 URL: https://issues.apache.org/jira/browse/HIVE-3185
             Project: Hive
          Issue Type: Improvement
    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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message