[
https://issues.apache.org/jira/browse/BEAM-12482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Siyuan Chen updated BEAM-12482:
-------------------------------
Description:
`withSchemaUpdateOptions` is only supported with WRITE_APPEND or WRITE_TRUNCATE
with paritioned table. 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.
[https://github.com/apache/beam/blob/a8a8b3ab1292ff408940ba4430c95bc754341589/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/WriteTables.java#L219]
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."
was:
withSchemaUpdateOptions is only supported with WRITE_APPEND or WRITE_TRUNCATE
with paritioned table. 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.
[https://github.com/apache/beam/blob/a8a8b3ab1292ff408940ba4430c95bc754341589/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/WriteTables.java#L219]
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."
> BigQueryIO failed to load data to temp table when withSchemaUpdateOptions is
> set.
> ---------------------------------------------------------------------------------
>
> Key: BEAM-12482
> URL: https://issues.apache.org/jira/browse/BEAM-12482
> Project: Beam
> Issue Type: Bug
> Components: io-java-gcp
> Reporter: Siyuan Chen
> Priority: P2
>
> `withSchemaUpdateOptions` is only supported with WRITE_APPEND or
> WRITE_TRUNCATE with paritioned table. 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.
> [https://github.com/apache/beam/blob/a8a8b3ab1292ff408940ba4430c95bc754341589/sdks/java/io/google-cloud-platform/src/main/java/org/apache/beam/sdk/io/gcp/bigquery/WriteTables.java#L219]
> 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."
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
