[GitHub] [beam] NichaRoj opened a new issue, #25755: [Bug]: BigQueryIO got JSON parsing error: No such field when there is no field, or field is empty string

["NichaRoj (via GitHub)" <gi...@apache.org>]

NichaRoj opened a new issue, #25755:
URL: https://github.com/apache/beam/issues/25755

   ### What happened?
   
   I tried searching for previous reports and didn't find anything.
   
   Currently writing custom Dataflow templates to write to BigQuery using Java SDK.
   
   ```
   <beam.version>2.45.0</beam.version>
   <bigquery.version>v2-rev20200719-1.30.10</bigquery.version>
   <google-api-client.version>1.30.10</google-api-client.version>
   <google-http-client.version>1.34.0</google-http-client.version>
   ```
   
   I am trying to run pipeline with `BigQueryIO.writeTableRows()` with schema specified, but mode not specified so it should be `NULLABLE`
   
   However, if `TableRow` from previous stage does not contain field, it gives error:
   ```
   Error while reading data, error message: JSON parsing error in row starting at position 16645: No such field: user_address.
   ```
   In temp file, the relevant object does not have the field shown in error.
   
   In another instance, `TableRow` from previous stage contains the field, but the field is an empty string. It gives error:
   ```
   Error while reading data, error message: JSON parsing error in row starting at position 0: No such field: user_address.
   ```
   
   
   ### Issue Priority
   
   Priority: 2 (default / most bugs should be filed as P2)
   
   ### Issue Components
   
   - [ ] Component: Python SDK
   - [X] Component: Java SDK
   - [ ] Component: Go SDK
   - [ ] Component: Typescript SDK
   - [X] Component: IO connector
   - [ ] Component: Beam examples
   - [ ] Component: Beam playground
   - [ ] Component: Beam katas
   - [ ] Component: Website
   - [ ] Component: Spark Runner
   - [ ] Component: Flink Runner
   - [ ] Component: Samza Runner
   - [ ] Component: Twister2 Runner
   - [ ] Component: Hazelcast Jet Runner
   - [ ] Component: Google Cloud Dataflow Runner


-- 
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.apache.org

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