Calculate avg on dynamic rolling window in vertica
We want to calculate avg value of each 1 hr data. We have a column in which we are storing epoch (timestamp) at which we got the data. We have different tables in which data are collected at different frequency like 5ms, 1min etc. We will have variable size window for 1hr in each table. With same query, we want to calculate avg for each table.