Null values in attributes not supported?

[beginner99]

I’m getting error trying to bulk insert via python. ({“error”:"unable to parse: NaN)

I then found this older thread:

Prevent Manticore from setting sql_attr_floatvalue to 0.000000 for null values

I have a MySql table with latitude and longitude columns like this `latitude` double DEFAULT NULL, `longitude` double DEFAULT NULL. When a row does not have data in these columns the cell just contains NULL. select * from geo_locations where city = 'london colney'; +-------+----------------+---------+---------------+---------------+--------------+------------+----------+-----------+ | id | country | state | county | city | country_code | state_code | latitud…

So I wonder if this still is the case? I can’t set attributes to null? This can be for string attributes or numeric ones. Can I instead omit them in the insert command?

[tomat]

you could omit attributes in the insert - this way they get to default values (numeric to 0).
However plain attribute can not have null - only JSON attributes could be null