Skip to content

Instantly share code, notes, and snippets.

@igorborgest
igorborgest / inner_join_vs_explode.sql
Created May 2, 2022 17:54
SparkSQL and Hive unnest examples.
-- REGULAR
WITH
ORDERS(order_id, dt) AS (
VALUES
(1, DATE('2022-01-01')),
(2, DATE('2022-01-02')),
(3, DATE('2022-01-03'))
),
ITEMS(item_id, order_id, price) AS (
VALUES