Google Bigquery error "Multiple definitions of field."

Question

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.

can you share with us your schema and an example of a row you are inputting into the table? — Willian Fuks

Mosha Pasumansky Mosha Pasumansky · Accepted Answer · 2017-06-28T16:53:04

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.

Google Bigquery error "Multiple definitions of field."

1 Answers