Presto Full [portable] Jun 2026

-- Find all sales and returns, even if one is missing WITH sales AS ( SELECT date, product_id, SUM(qty) AS sold FROM sales_table GROUP BY 1,2 ), returns AS ( SELECT date, product_id, SUM(qty) AS returned FROM returns_table GROUP BY 1,2 ) SELECT COALESCE(s.date, r.date) AS date, COALESCE(s.product_id, r.product_id) AS product_id, COALESCE(s.sold, 0) AS units_sold, COALESCE(r.returned, 0) AS units_returned, COALESCE(s.sold, 0) - COALESCE(r.returned, 0) AS net FROM sales s FULL OUTER JOIN returns r ON s.date = r.date AND s.product_id = r.product_id ORDER BY date, product_id;

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

✅