admin管理员组

文章数量:1290096

I'm working with an Avro file that contains an array field where each element can be either null or long. The Avro schema for the field looks something like this:

{
  "name": "myArray",
  "type": {
    "type": "array",
    "items": ["null", "long"]
  }
}

During the BigQuery load job, null elements in the array are filtered out. I need to preserve these null values as they are represented in the file, but I want to avoid modifying the Avro file.

Is there a way to load the Avro file to preserve the null elements in the array? Are there any configuration options or workarounds? JSON conversions? Default values?

本文标签: google cloud platformPreserving null elements in array when loading Avro to BigQueryStack Overflow