Availability of time_bucket_gapfill() in timescaledb extension
Hi everyone,
I'm currently experimenting with the extension timescaledb and trying to visually graph some timescale data.
In order to do this correctly, gap-filling the non-existent intervals is a must. Otherwise the representation of the dataset is skewed.
timescaledb offers this functionality via their time_bucket_gapfill() method. But if I try to run it, I get the following error message:
Any ideas how to go about this?
My query btw.:
any help is appreciated. thanks.
I'm currently experimenting with the extension timescaledb and trying to visually graph some timescale data.
In order to do this correctly, gap-filling the non-existent intervals is a must. Otherwise the representation of the dataset is skewed.
timescaledb offers this functionality via their time_bucket_gapfill() method. But if I try to run it, I get the following error message:
Failed to run sql query: function "time_bucket_gapfill" is not supported under the current "apache" license
Any ideas how to go about this?
My query btw.:
select
time_bucket_gapfill('1 hour', time) as hour,
count(update) as updates
from
app.update_log
where
time >= (now() - interval '3d') and time < now()
group by
hour
order by
hour ascany help is appreciated. thanks.
