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

Question

I would like to save the result set of the following query to a table.

SELECT

g, NEST(x) AS a

FROM 

(SELECT 1 AS g, 10 AS x), (SELECT 1 AS g, 20 AS x), (SELECT 1 AS g, 30 AS x), 
(SELECT 2 AS g, 100 AS x), (SELECT 2 AS g, 200 AS x)  

GROUP BY g

I use the web query composer with the options "Write if empty", "Allow Large Results: yes", "Flatten Results: no" and "Query priority: Interactive". I don't want to flatten query results.

Query failes: "Error: Unexpected. Please try again."

When I created a table with the following schema and selected the option "Append to table", I received the same error.

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

Thank you for any advice.

Answer 1

Waitting for answers