[BEAM-11047] BigQuery IO: Avro INTEGER values get converted to String objects

• Type: Bug
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Affects Version/s: 2.22.0, 2.23.0, 2.24.0
• Fix Version/s: Missing
• Component/s: io-java-gcp
• Labels: bigquery java
• Flags: Patch
• Assignee: Unassigned
• Reporter: Jonas Grabber
• Created: 09/Oct/20 14:51
• Updated: 13/Jan/22 21:48
• Resolved: 15/May/21 17:59

Description

For some reason, convertRequiredField used in BigQueryAvroUtils.convertGenericRecordToTableRow casts values with the Avro INTEGER type to Long, but then converts them to String objects via toString.

I'm quite unsure where convertGenericRecordToTableRow is used elsewhere, but we use it to utilize BigQuery's Storage API reads.

I'm fairly certain this is not expected behaviour because other types are converted properly and due to the cast to Long it's ensured that any values will fit into Long objects anyways.

Issue Links

• links to: GitHub Pull Request #13058