apache / apache/beam

[Bug]: BigQueryIO got JSON parsing error: No such field when there is no field, or field is empty string

Open
#25,755 0 comments 0 reactions 0 assignees View on GitHub
awaiting triage bug io java P2
Dominant language
Java
Stars
8.7k
Forks
4.7k
Avg merge
1d 20h
Merged PRs (30d)
196

Description

### 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.

```
2.45.0
v2-rev20200719-1.30.10
1.30.10
1.34.0
```

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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.