I am wondering when will the UNION operator be supported in MapD? Is there another way to merge two tables vertically. Thank you.
UNION operator; merge two tables vertically
hanX
#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