如何在google big查询中查询记录类型重复字段？

SELECT
  *,
  STRUCT(record_field.sub_field1, record_field.sub_field2) AS expanded_field
FROM
  table_name

SELECT
  *,
  expanded_field.sub_field1 AS repeated_field
FROM
  table_name,
  UNNEST([expanded_field]) AS expanded_field

SELECT
  repeated_field,
  COUNT(*) AS count
FROM
  (
    SELECT
      *,
      expanded_field.sub_field1 AS repeated_field
    FROM
      table_name,
      UNNEST([expanded_field]) AS expanded_field
  )
GROUP BY
  repeated_field
HAVING
  count > 1