Set Operators Supported, with the following Entry SQL level restrictions: • UNION is not supported. • UNION ALL is supported only in a subquery. 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.