SQL Functionality for the Driver for Apache Hive : Set Operators

Set Operators
Supported, with the following Entry SQL level restrictions:
The following example fails with Apache Hive because UNION ALL is used in a standard syntax:
SELECT * FROM t1 UNION ALL SELECT * FROM t2
To make the query work with Apache Hive, use a subquery:
SELECT * FROM (SELECT * FROM t1 UNION ALL SELECT * FROM t2) sq
In addition, INTERSECT or EXCEPT are not supported.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.