Google Bigquery error "Multiple definitions of field."

686 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 answers

3
Mosha Pasumansky 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.