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 2021/09/03 22:42: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=646509&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-646509 ]

ASF GitHub Bot logged work on BEAM-12482:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 03/Sep/21 22:41
            Start Date: 03/Sep/21 22:41
    Worklog Time Spent: 10m 
      Work Description: aaltay commented on pull request #15281:
URL: https://github.com/apache/beam/pull/15281#issuecomment-912848314


   What is the next step on this PR?
   
   @crcornwell - are you still planning to work on it? Should we close it?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 646509)
    Remaining Estimate: 0h
            Time Spent: 10m

> 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: Christopher Cornwell
>            Priority: P2
>          Time Spent: 10m
>  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.3.4#803005)