Default value for time series table

Hi All,

I am receiving simple data from an application to a clickhouse DB every min to check if app’s status is UP (at db status column data type is bool and value true) how could i specify a default value if there is no data for 1 min?

Thanks

Welcome

You could try a left join to a calendar table to fake the missing time