[BEAM-10071] TableFieldSchema Conversion fails for beamschema

• Type: Bug
• Status: Resolved
• Priority: P3
• Resolution: Fixed
• Affects Version/s: 2.20.0
• Fix Version/s: Not applicable
• Component/s: io-java-gcp
• Labels: GCP easy-fix patch
• Flags: Patch
• Assignee: Unassigned
• Reporter: Jasper Duizendstra
• Created: 24/May/20 18:29
• Updated: 22/Oct/21 13:18
• Resolved: 22/Oct/21 13:18

Description

field.setType(toStandardSQLTypeName(type).toString()); on line 310 of BigQueryUtils.java will fail with a java.lang.NullPointerException.

The cause is the construction around line 210 return BEAM_TO_BIGQUERY_TYPE_MAPPING.get(fieldType.getTypeName());

I believe the issue can be solved by adding the missing datatypes (CHAR, VARCHAR, NUMERIC, DATE, and BIT to the items on row 189