google-bigquery - 重复记录 - 嵌套和重复数据 - Java API

Question

我正在尝试使用 JAVA API 流式传输重复记录字段。它插入记录但具有空值。我使用的数据和模式来自谷歌的“嵌套和重复数据”示例

以下是代码片段:

      TableRow row = new TableRow();
      row.set("kind", "person");
      row.set("fullName", "P");
      row.set("age", "22");
      row.set("gender", "M");


      TableRow prow = new TableRow();
      prow.set("areaCode", 206);
      prow.set("number", 1234567);       
      row.set("phoneNumber", prow);

      JsonArray children = new JsonArray();

      JsonObject child1 = new JsonObject();
      child1.addProperty("name", "Jane");
      child1.addProperty("gender", "f");
      child1.addProperty("age", 6);       
      children.add(child1);

      JsonObject child2 = new JsonObject();
      child2.addProperty("name", "John");
      child2.addProperty("gender", "m");
      child2.addProperty("age", 15);          
      children.add(child2);

      row.set("children", children);


      TableDataInsertAllRequest.Rows rows = new TableDataInsertAllRequest.Rows();         
      rows.setJson(row);

      List  rowList = new ArrayList();
      rowList.add(rows);
      TableDataInsertAllRequest content = new TableDataInsertAllRequest().setRows(rowList);
      TableDataInsertAllResponse response = bigquery.tabledata().insertAll(projectId, "tmp", "person5", content).execute();

Answer 1

创建 List 而不是 JsonArray 的工作方式如下:

List<TableRow> children = new ArrayList<TableRow>();

TableRow child1 = new TableRow();
child1.set("name", "Jane");
child1.set("gender", "f");
child1.set("age", 6);       

TableRow child2 = new TableRow();
child2.set("name", "John");
child2.set("gender", "m");
child2.set("age", 15);

children.add(child1);
children.add(child2);