Big query DML insert-select as into repeated tables
<p>I have a table structure (table name: Recalled_transaction) as follows:</p>

<pre><code>[{
"name": "STR_NBR",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "RGSTR_NBR",
"type": "INTEGER",
"mode": "NULLABLE"
},
{
"name": "POS_TRANS_ID",
"type": "INTEGER",
"mode": "NULLABLE"
},
{
 "name": "SLS_DT",
"type": "DATE",
"mode": "NULLABLE"
},
{
"name": "TRANS_ORIG_SRC",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
  {
  "name": "POS_APPL_TYP_CD",
  "type": "STRING",
  "mode": "NULLABLE"
  },
  {
  "name": "USER_ID",
  "type": "STRING",
  "mode": "NULLABLE"
  }
 ]
},
{
"name": "RECALLED_TXN",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
  {
  "name": "POS_SEQ_NBR",
  "type": "STRING",
  "mode": "REPEATED"
  },
  {
  "name": "SUB_SYS_CD",
  "type": "STRING",
  "mode": "NULLABLE"
  }
 ]
 }
 ]
</code></pre>

<p>I would like to insert from a set of regular tables into this structure using insert-select as (DML in standard sql).  Has anyone done before.  Any help is appreciated.</p>

<p>Thanks</p>