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 Spark SQL because UNION ALL is used in a standard syntax:

SELECT * FROM t1 UNION ALL SELECT * FROM t2

To make the query work with Spark SQL, use a subquery:

SELECT * FROM (SELECT * FROM t1 UNION ALL SELECT * FROM t2) sq

In addition, INTERSECT or EXCEPT are not supported.