I'm running a query with a
select bar_tbl.thing1
from foo
cross join unnest(bar) as t(bar_tbl)
And got the error Error Query failed: Cannot unnest type: row
Why?
The bar column looks like this {thing1=abc, thing2=def}
Turns out I was trying to expand a row, which doesn't make sense. I should have just done
select bar.thing1
from foo
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With