skip to main content
SQL Functionality for the Driver for Apache Spark SQL : Set Operators
  

Try DataDirect Drivers Now

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 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.