Supported, with the following Entry SQL level restrictions:

  • UNION is not supported.

    Therefore, the following query fails:

    SELECT * FROM t1 UNION SELECT * FROM t2

  • UNION ALL is supported.

    Therefore, the following query works:

    SELECT * FROM t1 UNION ALL SELECT * FROM t2

    Note: For versions of Apache Hive 0.12 and earlier, UNION ALL is supported only in a subquery.

In addition, INTERSECT or EXCEPT are not supported.