javascript - BIGQuery - 函数 ARRAY_TO_STRING 没有匹配的签名

Question

运行下面的查询后

           SELECT ARRAY_TO_STRING( reporteeNames, '|') FROM 
         `appsflow-dev.PersonRequisition.ExternalNewHire`;

我遇到了错误

架构

Fieldname                           Type    Mode

reporteeNames                       RECORD  REPEATED    
reporteeNames.reporteeTitle         STRING  NULLABLE    
reporteeNames.reporteeName          RECORD  NULLABLE    
reporteeNames.reporteeName.display  STRING  NULLABLE    
reporteeNames.reporteeName.value    STRING  NULLABLE

请建议针对我的模式的解决方案。

Answer 1

您需要取消嵌套数组才能选择结构内的字段:

SELECT
  (SELECT STRING_AGG(reporteeName, '|')
   FROM UNNEST(reporteeNames)) AS names
FROM `your-project`.dataset.table

另见 working with arrays documentation .