您正在查询一个字符串和两个数组-整个过程基本上看起来像这样:
{ "publication_number": "US-8746747-B2", "assignee": [ "IPS Corporation鈥擶eld-On Division" ], "assignee_harm": [ "MCPHERSON TERRY R", "IPS CORPORATION鈥擶ELD ON DIVISION" ] }
这就是数据,您需要以某种方式决定如何对待它们的组合……要么交叉连接所有内容:
#standard SQLSELECt p.publication_number, assignee, assignee_harmonized.name AS assignee_harmFROM `patents-public-data.patents.publications_201710` AS p ,p.assignee assignee ,p.assignee_harmonized AS assignee_harmonizedWHERe p.publication_number IN ('US-6044964-A','US-8746747-B2')
..它为您提供关系数据..或将其保留为两个单独的数组:
#standard SQLSELECt p.publication_number, assignee, ARRAY( (SELECT name FROM p.assignee_harmonized)) AS assignee_harmFROM `patents-public-data.patents.publications_201710` AS pWHERe p.publication_number IN ('US-6044964-A','US-8746747-B2')
您也可以将此嵌套结果另存为bq中的表。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)