This repository was archived by the owner on Mar 6, 2026. It is now read-only.
Repository navigation
This repository was archived by the owner on Mar 6, 2026. It is now read-only.
Cannot insert NaN and non-finite float values using Client.insert_rows() #696
Description
Trying to insert a NaN using Client.insert_rows fails. I tracked it down to
def _float_to_json(value):
"""Coerce 'value' to an JSON-compatible representation."""
return value if value is None else float(value)
which should return "NaN" to be compatible with the REST API. Currently it returns an actual nan float value. Probably similar issues occur with other non-finite floats.
Environment details
- OS type and version:
- Python version:
Python 3.6.8 - pip version:
pip 21.1 google-cloud-bigqueryversion:2.20.0
Steps to reproduce
- Try to insert a NaN value into existing table
Code example
from google.cloud.bigquery import Client
client = Client(project='bar')
client.insert_rows(table=client.get_table('foo'), rows=[{'bar': float('NaN')}])Stack trace
google.api_core.exceptions.BadRequest: 400 POST (REDACTED): Invalid JSON payload received. Unexpected token.
json": {"bar": NaN}, "insertId": "1
Activity
wmdrichards commentedon Jun 11, 2021
For anyone else running into this, using
insert_rows_jsonis a valid workaround, as long as the row is already json-compatible[-]Cannot insert NaN values using Client.insert_rows[/-][+]Cannot insert NaN and non-finite float values using Client.insert_rows()[/+]plamut commentedon Jun 29, 2021
Thanks for reporting and researching that. It turned out that non-finite floats were indeed problematic, too.