I am wondering when will the UNION operator be supported in MapD? Is there another way to merge two tables vertically. Thank you.
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);
The UNION [or UNION ALL] operator is not implemented in MapD [Community on AWS] yet…