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