[
https://issues.apache.org/jira/browse/BEAM-13158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17506371#comment-17506371
]
Beam JIRA Bot commented on BEAM-13158:
--------------------------------------
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.
> "Dead letter" handling for problem rows in BigQueryIO Storage Write API
> -----------------------------------------------------------------------
>
> Key: BEAM-13158
> URL: https://issues.apache.org/jira/browse/BEAM-13158
> Project: Beam
> Issue Type: New Feature
> Components: io-java-gcp
> Reporter: Sergei Lilichenko
> Priority: P2
> Labels: stale-P2
>
> A single invalid row causes the BigQueryIO transform and the whole pipeline
> to fail. The desired behavior would be to allow control of the error handling
> - either fail on any validation failure (current behavior) or return the list
> of failed records through the WriteResult.
> There are two places where the exception occurs - Json to protobuf conversion
> and the BigQuery backend.
> Example of the exception caused by the conversion:
> {code}
> io.grpc.StatusRuntimeException: INVALID_ARGUMENT: The proto field mismatched
> with BigQuery field at D586b3f9a_1543_4dbe_87ff_ef786d6803c2.bytes_sent, the
> proto field type string, BigQuery field type INTEGER Entity:
> projects/event-processing-demo/datasets/bigquery_io/tables/events/streams/Cic2MzUyMTYxYy0wMDAwLTI2MjktOGVjYy1mNDAzMDQ1ZWY5Y2U6czI
> {code}
> Example of the exception caused by the BigQuery backend:
> {code}
> io.grpc.StatusRuntimeException: INVALID_ARGUMENT: Field dst_ip: STRING(15)
> has maximum length 15 but got a value with length 54 Entity:
> projects/event-processing-demo/datasets/bigquery_io/tables/events/streams/CiQ2MzRkOGM5Mi0wMDAwLTI2MjktOGVjYy1mNDAzMDQ1ZWY5Y2U
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
