Thank you, David, that's what I had been looking for!
On Sun, Feb 20, 2022 at 3:52 AM David Anderson wrote:
> Matthias,
>
> You can use a CROSS JOIN UNNEST, as mentioned very briefly in the docs [1].
>
> Something like this should work:
>
> SELECT
> id, customerid, productid, quantity, ...
> F
Matthias,
You can use a CROSS JOIN UNNEST, as mentioned very briefly in the docs [1].
Something like this should work:
SELECT
id, customerid, productid, quantity, ...
FROM
orders
CROSS JOIN UNNEST(entries) AS items (productid, quantity, unit_price,
discount);
[1]
https://nightlies.apache.or
