How to aggregate and push data for certain period?

I'm working with huge table in Vertica db, and every day need to get some aggregation about last days, can I make a live Top-K Projection, that will work for last day or not?

I need something that will aggregate data for the current day(or previous) and push it to table with information about all previous day.

Leave a Comment

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