I’m getting the following error:
ERROR: continuous aggregate view must include a valid time bucket function:
For the following query to create a materialized view:
create materialized view my_table_5min
with (timescaledb.continuous) as
select time_bucket(‘5 min’, close_time, interval ‘-5 min’) + ‘5 min’ as close_time,
symbol,
max(high) as high,
min(low) as low,
first(open, close_time) as open,
last(close, close_time) as close,
sum(volume) as volume,
from my_table
group by close_time, symbol;
I saw a github issue saying that this feature is not supported. What is the workaround to perform aggregation so that the time is the end of the bucket as opposed to the beginning.