Set Operators
- Last Updated: August 19, 2015
- 1 minute read
- DataDirect Connectors
- JDBC
- Apache Spark SQL 6.0
- Documentation
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
In addition, INTERSECT and EXCEPT are not supported.