You have a few options when it comes to blank values. InfluxQL supports fill(<fill_options>) which replaces those blank values with the relevant fill_option. One of those options is none; a query with fill(none) reports no timestamp and no value for time intervals with no data.
My Question is more specific. What if I want to fetch the row in which the field value is blank? in the above example the second row.
Also, is fill function allowed to use without a function in projection?
select * from (select * from m fill(999999999)) where f2 = 999999999
The database doesn’t store nulls, so there’s no simple query for this, but if there’s a value you know will never occur, you can fill with it, and then query for that value.
No worries! I’m not sure I have it quite figured out either. It’s hard to replicate. Give me a little time to try to get a working example closer to your example.