Hello guys,
I'm working with Pub/Sub's BigQuery Subscription on different kinds of data types and there are several ambiguities here:
- When we send float data with a 0.0 value, it is stored as Null at BigQuery table (data is stored in FLOAT column). How will we know if incoming data has come as 0.0 or it hasn't arrived?
- When we send float data other than 0.0, sometimes it is getting additional decimals. For example, I'm sending 0.1 as a value but BigQuery stores it as 0.10000000149011612. Where does this precision come from and why? What kind of logic rounds value to an uncertain decimal value?
- When we send boolean data, if it's not true, BigQuery stores it as null. How will we know if incoming data has come as false or null?
Best regards,
Cagri
LinkedIn
Twitter
