You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/04/10 12:47:00 UTC
[jira] [Work logged] (BEAM-12482) BigQueryIO failed to load data to temp table when withSchemaUpdateOptions is set.
[ https://issues.apache.org/jira/browse/BEAM-12482?focusedWorklogId=755012&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-755012 ]
ASF GitHub Bot logged work on BEAM-12482:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 10/Apr/22 12:46
Start Date: 10/Apr/22 12:46
Worklog Time Spent: 10m
Work Description: github-actions[bot] commented on PR #16303:
URL: https://github.com/apache/beam/pull/16303#issuecomment-1094265910
This pull request has been marked as stale due to 60 days of inactivity. It will be closed in 1 week if no further activity occurs. If you think that’s incorrect or this pull request requires a review, please simply write any comment. If closed, you can revive the PR at any time and @mention a reviewer or discuss it on the dev@beam.apache.org list. Thank you for your contributions.
Issue Time Tracking
-------------------
Worklog Id: (was: 755012)
Time Spent: 3h 50m (was: 3h 40m)
> 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: Marco Robles
> Priority: P2
> Time Spent: 3h 50m
> 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)