title: JSON Schema - bq load errors
body: <p>This file is part json used:</p>
  
  <pre><code>{"body1": {"posts": {"children": [{"row": {"acceptedanswerid": "26", "answercount": "5", "body": "&lt;p&gt;Now that the Engineer update has come, there will be lots of Engineers building up everywhere.  How should this best be handled?&lt;/p&gt;\n", "commentcount": "7", "creationdate": "2010-07-07T19:06:25.043", "id": "1", "lastactivitydate": "2010-08-27T22:38:43.840", "lasteditdate": "2010-08-27T22:38:43.840", "lasteditordisplayname": "", "lasteditoruserid": "56", "owneruserid": "11", "posttypeid": "1", "score": "10", "tags": "&lt;strategy&gt;&lt;team-fortress-2&gt;&lt;tactics&gt;", "title": "In Team Fortress 2, what is a good strategy to deal with lots of engineers turtling on the other team?", "viewcount": "1166"}}, {"row": {"acceptedanswerid": "184", "answercount": "3", "body": "&lt;p&gt;I know I can create a Warp Gate and teleport to Pylons, but I have no idea how to make Warp Prisms or know if there's any other unit capable of transporting.&lt;/p&gt;\n\n&lt;p&gt;I would in particular like this to built remote bases in 1v1&lt;/p&gt;\n", "commentcount": "2", "creationdate": "2010-07-07T19:07:58.427", "id": "2", "lastactivitydate": "2010-07-08T00:21:13.163", "lasteditdate": "2010-07-08T00:16:46.013", "lasteditordisplayname": "", "lasteditoruserid": "68", "owneruserid": "10", "posttypeid": "1", "score": "5", "tags": "&lt;starcraft-2&gt;&lt;how-to&gt;&lt;protoss&gt;", "title": "What protoss unit can transport others?", "viewcount": "398"}}]}}}
  </code></pre>
  
  <p>This is the schema used:</p>
  
  <pre><code>{
   "name":"body1", "type": "STRING",
   "name":"posts", "type": "STRING",  
   "name":"children", "type":"RECORD",
   "fields": [    
      {"name": "row", "type": "STRING"},
      {"name": "acceptedanswerid", "type": "STRING"},
      {"name": "answercount", "type": "STRING"},
      {"name": "body", "type": "STRING"},
      {"name": "commentcount", "type": "STRING"},
      {"name": "creationdate", "type": "STRING"},
      {"name": "id", "type": "string"},
      {"name": "lasteditdate", "type": "integer"},
      {"name": "lasteditordisplayname", "type": "string"},
      {"name": "lasteditoruserid", "type": "string"},
      {"name": "owneruserid", "type": "string"},
      {"name": "posttypeid", "type": "string"},
      {"name": "score", "type": "string"},
      {"name": "tags", "type": "string"},
      {"name": "title", "type": "string"},
      {"name": "viewcount", "type": "string"}
  ]
  }
  </code></pre>
  
  <p>The problem is in the implementation of the scheme. But I didn't find the detailed scheme to build the model. Anyone can help me?</p>
  
  <p>Following the suggestion of Gil, I modified your original design for this valid json:</p>
  
  <pre><code>{
  "name":"body1", "type": "RECORD",
  "fields": [
  {"name":"posts", "type": "RECORD",
  "fields": [
      {"name":"children", "type": "RECORD",
      "fields": [    
          {"name": "row", "type": "STRING"},
          {"name": "acceptedanswerid", "type": "STRING"},
          {"name": "answercount", "type": "STRING"},
          {"name": "body", "type": "STRING"},
          {"name": "commentcount", "type": "STRING"},
          {"name": "creationdate", "type": "STRING"},
          {"name": "id", "type": "string"},
          {"name": "lasteditdate", "type": "integer"},
          {"name": "lasteditordisplayname", "type": "string"},
          {"name": "lasteditoruserid", "type": "string"},
          {"name": "owneruserid", "type": "string"},
          {"name": "posttypeid", "type": "string"},
          {"name": "score", "type": "string"},
          {"name": "tags", "type": "string"},
          {"name": "title", "type": "string"},
          {"name": "viewcount", "type": "string"}
      ]}]}]}
  </code></pre>
  
  <p>The bq command return:</p>
  
  <blockquote>
    <ul>
    <li>File: 0 / Offset:0 / Line:1 / Column:8 / Field:body1: no such field</li>
    </ul>
  </blockquote>