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:

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 asc

  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 asc

  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 asc

  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 asc

any help is appreciated. thanks.

Availability of time_bucket_gapfill() in timescaledb extension

Similar Threads

Similar Threads

Similar Threads