代替CROSS JOIN,使用LEFT JOIN。这将为空数组返回一行包含null的行。您可能也对文档中的使用数组主题感兴趣。
#Standardsql
WITH 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 tableA
LEFT JOIN UNNEST(L_id) AS value;