Is there a way to write 'NaN' to BigQuery using the
Python beam.io.BigQuerySink?

It complains that NaN is not supported in JSON if I try using float('NaN').

Context: given that null values are not supported in repeated fields for
BigQuery (e.g. having [0, None, 1]), I like to find a way to represent
'None' values for numeric types. I thought using NaN may be a good
workaround if possible. Any 'special' value would work for this purpose
actually.

Thanks,
Asha

Reply via email to