谷歌BigQuery，我在使用'unnest‘函数时丢失了null行

WITH data_with_offset AS (
  SELECT *, ARRAY_LENGTH(array_column) AS array_length, 
    ARRAY(SELECT AS STRUCT * FROM UNNEST(array_column) WITH OFFSET) AS unnested
  FROM your_table
)
SELECT * FROM data_with_offset

WITH data_with_offset AS (
  SELECT *, ARRAY_LENGTH(array_column) AS array_length, 
    ARRAY(SELECT AS STRUCT * FROM UNNEST(array_column) WITH OFFSET) AS unnested
  FROM your_table
)
SELECT * FROM data_with_offset
WHERE unnested IS NULL