Vertica 6.1 supports INTERSECT, MINUS and EXCEPT
Posted: Wed Dec 12, 2012 4:45 pm
Great news! The latest version of Vertica (6.1) now supports the INTERSECT, MINUS and EXCEPT set operators.
Below are several examples using the following data:
1. INTERSECT example:
2. MINUS example:
3. EXECPT example:
Below are several examples using the following data:
Code: Select all
dbadmin=> SELECT name FROM dba_team;
name
--------
Peng C
Jim K
Tom L
Pat K
(4 rows)
Code: Select all
dbadmin=> SELECT name FROM bi_team;
name
-----------
Dan J
Jessica D
Jerry M
Bill K
Tom K
Susan Y
Jessica W
Jim K
(8 rows)
Code: Select all
dbadmin=> SELECT name FROM dba_team
dbadmin-> INTERSECT
dbadmin-> SELECT name FROM bi_team;
name
-------
Jim K
(1 row)
Code: Select all
dbadmin=> SELECT name FROM bi_team
dbadmin-> MINUS
dbadmin-> SELECT name FROM dba_team;
name
-----------
Bill K
Dan J
Jerry M
Jessica D
Tom K
Jessica W
Susan Y
(7 rows)
Code: Select all
dbadmin=> SELECT name FROM dba_team
dbadmin-> EXCEPT
dbadmin-> SELECT name FROM bi_team;
name
--------
Peng C
Pat K
Tom L
(3 rows)