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.





Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file