google bigquery - Save a result set containing repeated field to a destination table -

google bigquery - Save a result set containing repeated field to a destination table -

i save result set of next query table.

select g, nest(x) (select 1 g, 10 x), (select 1 g, 20 x), (select 1 g, 30 x), (select 2 g, 100 x), (select 2 g, 200 x) grouping g

i utilize web query composer options "write if empty", "allow big results: yes", "flatten results: no" , "query priority: interactive". don't want flatten query results.

query failes: "error: unexpected. please seek again."

when created table next schema , selected alternative "append table", received same error.

{ "fields": [ { "name": "g", "type": "integer" }, { "name": "a", "type": "integer", "mode": "repeated" } ] }

thank advice.

this known issue nest function , flattenresults set false: 2 aren't compatible each other @ present. we'd prepare don't have eta underlying issue nontrivial.

if have existing table repeated field, should able select , output repeated field using flattenresults set false.

google-bigquery