Presto Full New! -

SELECT a.column1, b.column2 FROM table_a a FULL OUTER JOIN table_b b ON a.join_key = b.join_key;

You can usually find the official PDF via IEEE Xplore or on the PrestoDB/Presto Software Foundation websites under their publications section. presto full

FULL JOIN requires because both datasets must be distributed to matching nodes. Presto must retain both sides until matching is complete. SELECT a

Beyond technology and home goods, "presto" retains its original roots in music and language. presto full