UNION operator; merge two tables vertically

[ypershin]

I am wondering when will the UNION operator be supported in MapD? Is there another way to merge two tables vertically. Thank you.

[hanX]

Hi,

I can think of 2 workaround.

Using “UNION ALL”, then use “SELECT DISTINCT” to remove the duplicates.

Or, use SELECT * FROM A UNION ALL SELECT * FROM B WHERE PK NOT IN (SELECT PK FROM A);

Cheers

[ypershin]

The UNION [or UNION ALL] operator is not implemented in MapD [Community on AWS] yet…