[
https://issues.apache.org/jira/browse/BEAM-6298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17122981#comment-17122981
]
Beam JIRA Bot commented on BEAM-6298:
-------------------------------------
This issue is P2 but has been unassigned without any comment for 60 days so it
has been labeled "stale-P2". If this issue is still affecting you, we care!
Please comment and remove the label. Otherwise, in 14 days the issue will be
moved to P3.
Please see https://beam.apache.org/contribute/jira-priorities/ for a detailed
explanation of what these priorities mean.
> Can not insert into BigQuery table that is not empty
> ----------------------------------------------------
>
> Key: BEAM-6298
> URL: https://issues.apache.org/jira/browse/BEAM-6298
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql
> Affects Versions: 2.10.0
> Reporter: Luat Nguyen
> Priority: P2
> Labels: stale-P2
>
> There is a Exception when I try to insert into BigQuery table that is not
> empty.
> Example code Beam SQL:
> {code:java}
> BeamSqlRelUtils.toPCollection(pipeline, sqlEnv.parseQuery("INSERT INTO
> D_CARD_LITE(DIM_ID) VALUES('xxxx')")){code}
> The exception messages as below:
> {code:java}
> java.lang.IllegalStateException: BigQuery table is not empty:
> mydataset:samples.D_CARD_LITE.
> at com.google.common.base.Preconditions.checkState(Preconditions.java:518)
> at
> org.apache.beam.sdk.io.gcp.bigquery.BigQueryHelpers.verifyTableNotExistOrEmpty(BigQueryHelpers.java:470)
> at
> org.apache.beam.sdk.io.gcp.bigquery.BigQueryIO$Write.validate(BigQueryIO.java:1564)
> at
> org.apache.beam.sdk.Pipeline$ValidateVisitor.enterCompositeTransform(Pipeline.java:641)
> at
> org.apache.beam.sdk.runners.TransformHierarchy$Node.visit(TransformHierarchy.java:645)
> at
> org.apache.beam.sdk.runners.TransformHierarchy$Node.visit(TransformHierarchy.java:649)
> at
> org.apache.beam.sdk.runners.TransformHierarchy$Node.visit(TransformHierarchy.java:649)
> at
> org.apache.beam.sdk.runners.TransformHierarchy$Node.access$600(TransformHierarchy.java:311)
> at
> org.apache.beam.sdk.runners.TransformHierarchy.visit(TransformHierarchy.java:245)
> at org.apache.beam.sdk.Pipeline.traverseTopologically(Pipeline.java:458)
> at org.apache.beam.sdk.Pipeline.validate(Pipeline.java:577)
> at org.apache.beam.sdk.Pipeline.run(Pipeline.java:312)
> at org.apache.beam.sdk.Pipeline.run(Pipeline.java:299){code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
