You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "Beam JIRA Bot (Jira)" <ji...@apache.org> on 2022/03/11 16:59:00 UTC
[jira] [Commented] (BEAM-12482) BigQueryIO failed to load data to temp table when withSchemaUpdateOptions is set.
[ https://issues.apache.org/jira/browse/BEAM-12482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17505013#comment-17505013 ]
Beam JIRA Bot commented on BEAM-12482:
--------------------------------------
This issue is assigned but has not received an update in 30 days so it has been labeled "stale-assigned". If you are still working on the issue, please give an update and remove the label. If you are no longer working on the issue, please unassign so someone else may work on it. In 7 days the issue will be automatically unassigned.
> 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
> Assignee: Miguel Anzo
> Priority: P2
> Labels: stale-assigned
> Time Spent: 3h 40m
> Remaining Estimate: 0h
>
> `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.
> [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.20.1#820001)