Hi
I am encountering an issue that if a wrong data with a wrong data type is inserted into a new measurement, then the measurement by default is expecting that type of data.
For example, I created a new measurement “sensor_status” and there is a field temperature_sesor_status which is boolean.
However, initially, the temperature_sesor_status field was mistakenly sent as a string from the hardware. After we fixed this error, we found that InfluxDB still expects temperature_sesor_status to be a string, it is throwing errors about “wrong type”.
We are using a third-party cloud service (EMQX) to insert data directly into the measurement (without manually creating the measurement). Is there a way to predefine a field type? This way, if temperature_sesor_status is sent as a string, it will be rejected, rather than setting the field type to string and then rejecting subsequent boolean values.
Additionally, I’m not sure how to delete a measurement in Data Explorer. Is there a method or steps to do that?
Any help would be appreciated. Thank you!
