Error message (example):
Union is not supported. Use Union All instead
Currently, there is no support for the UNION operation.
UNION removes duplicate records (where all columns in the results are the same. Effectively, this is a
SELECT DISTINCT on the result set.).
UNION ALL does not remove duplicates
If you know that all the records returned are unique from your union, use