Google Bigquery error "Multiple definitions of field."

705 Views Asked by At

I'm using the google cloud node library pushing JSON record to a bigquery table.

I'm getting a lot of PartialFailureError with message "Multiple definitions of field."

"errors": [
  {
    "message": "Multiple definitions of field.",
    "reason": "invalid"
  }
]

What does this error mean. I've looked in the row data and compared that to the schema and haven't seen anything strange in terms of repeated fields or duplicate entries.

1

There are 1 best solutions below

3
On BEST ANSWER

This error means that some field (alas error message doesn't say which one), was defined in schema as repeated (i.e. JSON array), but was not repeated - or vice versa.