在BigQuery中跨多个数组列的高级UNNEST
表:
sql:
select id,first_name,address_history.address,address_history.city
from 'table'
SELECT id. firstname, address.address, address.city2 FROM JJDatasets.my-table. UNNEST(address-history) as address
表:
sql:
select id,first_name,address_history.address,address_history.city
from 'table'
SELECT id. firstname, address.address, address.city2 FROM JJDatasets.my-table. UNNEST(address-history) as address