[jira] [Commented] (BEAM-13158) "Dead letter" handling for problem rows in BigQueryIO Storage Write API

["Beam JIRA Bot (Jira)" <ji...@apache.org>]

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