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

        

Reply via email to