Google BigQuery: Error: Invalid schema update. Field has changed mode from REQUIRED to NULLABLE

Question

I'm trying to append the results of a query to another table.

It doesn't work and sends out the following error:

Error: Invalid schema update. Field X has changed mode from REQUIRED to NULLABLE.

The field X is indeed REQUIRED, but I don't try to insert any NULL-values into that specific column (the whole table doesn't have a single NULL value).

This looks like a bug to me. Anyone knows a way to work around this issue?

Please share the query (and any other parameters used to configure the request to BigQuery). Legacy SQL or standard SQL? — Elliott Brossard, Mar 13 '18 at 14:47
I switched from Legacy SQL to Standard SQL and the issue was gone. Something to keep in mind next time. Thanks! — Mark Engelsman, Mar 19 '18 at 10:30

score 1 · Accepted Answer · answered Mar 20 '18 at 08:29

1

The issue is fixed after switching from Legacy SQL to Standard SQL.

answered Mar 20 '18 at 08:29

Xiaoxia Lin

736
6
16

Google BigQuery: Error: Invalid schema update. Field has changed mode from REQUIRED to NULLABLE

1 Answers1

Linked