将数据从一个 BigQuery 表插入到另一个在 group by 上返回 0 行

我试图通过运行下面显示的查询将数据从一个 BigQuery 表插入到另一个表，但我得到 0 行作为回报。但是，如果我取出Survey列，我会得到正确的行数作为回报。

两个嵌套字段都具有相同类型的架构。我也检查并仔细检查了列名，但似乎无法弄清楚Survey字段有什么问题。

INSERT INTO destination_table
(
  Title, Description, Address, Survey
)
SELECT
  Title as Title,
  Description as Description,
  
  [STRUCT(
         ARRAY_AGG(STRUCT(Address_Instance.Field1, Address_Instance.Field2)) AS Address_Record 
  )]
  as Address,
  
  [STRUCT(
         ARRAY_AGG(STRUCT(Survey_Instance.Field1, Survey_Instance.Field2)) AS Survey_Record
  )]
  as Survey
  
FROM
   source_table,
   UNNEST(Survey) AS Survey,
   UNNEST(Survey_Instance) as Survey_Instance,
   
GROUP BY
  Title,
  Description

我的源表的架构如下所示：

[
  {
    "name": "Title",
    "type": "STRING"
  },
  {
    "name": "Description",
    "type": "STRING"
  },
  {
    "name": "Address",
    "type": "RECORD",
    "mode": "REPEATED",
    "fields": [
      {
        "name": "Address_Instance",
        "type": "RECORD",
        "mode": "REPEATED",
        "fields": [
          {
            "name": "Field1",
            "type": "STRING"
          },
          {
            "name": "Field2",
            "type": "STRING"
          }
        ]
      }
    ]
  },
  {
    "name": "Survey",
    "type": "RECORD",
    "mode": "REPEATED",
    "fields": [
      {
        "name": "Survey_Instance",
        "type": "RECORD",
        "mode": "REPEATED",
        "fields": [
          {
            "name": "Field1",
            "type": "STRING"
          },
          {
            "name": "Field2",
            "type": "STRING"
          }
        ]
      }
    ]
  },
]

在映射到目标表时，我重命名嵌套的重复记录，但这不会导致任何问题。我想知道我是否忽略了一些重要的事情并需要一些建议和建议。基本上是一组额外的眼睛来帮助我弄清楚我做错了什么。希望得到一些帮助。提前致谢。