BigQueryIO failed to load data to temp table when withSchemaUpdateOptions is set.

[damccorm]

withSchemaUpdateOptions is only supported with WRITE_APPEND or WRITE_TRUNCATE with paritioned table. This is noted in the documentation:

https://github.com/apache/beam/blob/master/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/BigQueryIO.java#L1965

When the temp files are spilt to multiple load jobs, the write disposition is set to WRITE_TRUNCATE for the temporary tables in favor of retries.

beam/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/WriteTables.java

Line 219 in a8a8b3a

writeDisposition = WriteDisposition.WRITE_TRUNCATE;

And the loading would fail with error 

"Schema update options should only be specified with WRITE_APPEND disposition, or with WRITE_TRUNCATE disposition on a table partition."

 

Imported from Jira BEAM-12482. Original Jira may contain additional context.
Reported by: sychen.

[damccorm]

Unable to assign user @MarcoRob. If able, self-assign, otherwise tag @damccorm so that he can assign you. Because of GitHub's spam prevention system, your activity is required to enable assignment in this repo.