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/18 17:29:00 UTC

[jira] [Assigned] (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:all-tabpanel ]

Beam JIRA Bot reassigned BEAM-12482:
------------------------------------

    Assignee:     (was: Miguel Anzo)

> 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
>              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)