UNION operator; merge two tables vertically


#1

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


Is there support for selecting from multiple tables?
#2

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


#3

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