Apache Pinot

Hi team,  NaN is returned with below query. But how to locate records with value=NaN? I tried select * from table_name where value = NaN. It didn’t work.
```select min(value) from table_name```

What’s the data type for value? And was it null in the input?

I use jsonPathDouble to extract value
{
        “columnName”: “value”,
        “transformFunction”: “jsonPathDouble(json_info, ‘$. value’)”
}
Not able to locate kafka data in this case. So locally I’ve tried to test “null”, null, “”, “NaN”.  Pinot will transform value to 0. Couldn’t figure out how did NaN happened.