Google BigQuery，使用“ unnest”功能时我丢失了空行

代替CROSS JOIN，使用LEFT
JOIN。这将为空数组返回一行包含null的行。您可能也对文档中的使用数组主题感兴趣。

#StandardSQLWITH tableA AS (  SELECt ["T001", "T002", "T003"] AS T_id, [1, 5] AS L_id  UNIOn ALL  SELECT ["T008", "T009"] AS T_id, NULL AS L_id)SELECT * FROM tableALEFT JOIN UNNEST(L_id) AS value;