google-bigquery - 如何在 BQ 中将数据插入包含结构数据类型的表中

Question

在尝试将数据插入下表时，我收到以下错误消息。

--create table mydataset.struct_1(x struct<course string,id int64>)
insert into `mydataset.struct_1` (course,id)  values("B.A",12)

Error: Column course is not present in table mydataset.struct_1 at [2:35]

标签： google-bigquery

Answer 1

-- CREATE TABLE mydataset.struct_1(x STRUCT<course STRING,id INT64>)
INSERT INTO `mydataset.struct_1` (x)  VALUES(STRUCT("B.A",12))